• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

using databases

when we are programming in Vb and when we Are using access for database desigining will a problem occure for the speed of the programme ?
1 Solution
no. the speed of the program is completely determined by the program design and the size of the database you're using. If this is not the answer you were looking for, please be more descriptive.
Speed Constraints  can be Following

1. No. of Users Using Application at any given point of Time

2. Server / Database Server Hardware & Network Hardware viz NIC n Hub

3. Types of Cursors u r using - Dynamic Cursors are Costly
    Try Using Disconnected Recordsets

4 .Application design - Try Localizing Variables ie " Dim rsNew as RecordSet"
   instead  of Private or Public

5. Where Possible Try creating  Common  Functions

6. Lastly the no. of Queries u will be firing on Database
    Try Using Stored queries , it will also depend on volume of Data being     punched in

if there is anything left , i would like to know that as well
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now