Question about Computers & Internet
I have a system developed in vb6 + access97 as database, my database is only 67mb why it's getting slow in retrieving the data when using the system... thanks
There could be a lot of reasons ranging from a virus to simple maintenance to code that is not written correctly (you can be your own worst enemy). Here are a set of things you might wish to do to determine if the problem is with your design or elsewhere.
First.....using both Ccleaner and WiseRegistry cleaner (free downloads from a variety of places on the internet ...i.e cnet downloads). Run these. With Ccleaner just take it's advice and get rid of all. With Wise just get rid of the green checked boxes.
Next...Run scandisk in through mode set to autofix.
Next...Reboot and run your application.
Does it run faster or slower?
If faster good but if still not "fast" (and I have no idea what fast means because I don't know the application is or the machine you are working with....i.e. a Pentium III at 550 htz with Xp loaded is not going to be a winner) that would indicate you fixed some problem (more likely just maintenace related but a cross linked file could have also been a culprit - and if so the fix may have eliminated some code and your application may not work so have a back up).
If the application response time is the same (and time it before you do all the above work so you have a bench mark...i.e. from the time you execute the program until there is some sort of result) more than likely you are either underpowered (despite the size of your database) or Access has a problem or your machine is too small or you have a VB code problem. If you can put your application on a Cd and run it on a faster machine (assuming you have an older machine) and it's the same or faster that tells you something.
Next there are some free utilities on the net that will check your code for syntax in addition to those in VB (haven't used it for a long time) and maybe even some better stuff (from my old days) at the Microsoft VB support site (within Microsoft somewhere).
This is what I would do before I hacked through all the code (if you have written a bunch). On the other hand if you have written just a few pages you might want to (when fresh in the morning) go through it again....stack - buffer - loop problems could be embedded.
If all this fails consider the following possibilities....Access is corrupted (trust me it happens) or some Windows file is corrupted. You probably know (version dependent) what you have for file verification and if you have restore ability you may want to go back to a prior point in time when it was running faster.
The net result of all this will pointyou in "some" direction. The reason I suggest the maintenance stuff first is (as stated) it gives you a clean slate (no suspicions relative to dumb-dumb problem) prior to spending more time.
And opps....I forgot.....if you don't use Spybot search and Destroy and Avast or AVg (anti-virus)....(all of these are free) you should run them before you reboot but after you scan.
This is fairly parochial but without the code and a lot of additional information it's the best I can do. If you suspect you have a code problem....you can paste pieces of it on other forums....you will get some feedback. Hope this helps...Tango.
Posted on Jan 27, 2008
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Jun 14, 2011 | Microsoft Visual Basic 6.0 for PC
Jan 27, 2010 | Microsoft Visual Basic 6.0 for PC
May 26, 2009 | Microsoft Windows XP Professional
Apr 22, 2009 | Microsoft Visual Basic 6.0 for PC
Dec 15, 2008 | Microsoft Windows Server Standard 2003 for...
Dec 08, 2008 | Computers & Internet
Sep 30, 2008 | Project Justice for Dreamcast
Sep 06, 2008 | Computers & Internet
Feb 21, 2008 | Microsoft Windows XP Professional With...
Nov 10, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)
90 people viewed this question
Usually answered in minutes!