accurates
asked on
Why is my app running slowly?
I built a custom database using DBASE V tables in Delphi.
When running on my computer, I search through 14000 plus records in a matter of around 3 seconds.
When on my customer's PC (which is 50mhz faster than mine), It takes around 30 to 40 seconds to search for the same records.
Both Laptops have 256 megabytes of RAM.
Any Ideas?????
When running on my computer, I search through 14000 plus records in a matter of around 3 seconds.
When on my customer's PC (which is 50mhz faster than mine), It takes around 30 to 40 seconds to search for the same records.
Both Laptops have 256 megabytes of RAM.
Any Ideas?????
DragonSlayer
umm... did you index the tables?
Seems it's problem with BDE configuration
ASKER
The BDE Configuration is the same on both computers.
The tables all have multiple indexes.
The tables all have multiple indexes.
What OS is on the customer's machine? If the OS is Win9x or ME then it could be an issue of System Resources, which is to say they may have too many programs running at the same time causing the System Resources to run quite low. In the case of System Resources the amount of RAM won't matter. Even if the System Resource percentage is not the problem the customer could still have a lot memory hungry programs running and the swap file is being used which would dramatically slow down things. Have them close down most of the programs they are running and see if this helps speed up things for you program.
Is the CPU on the customer's mahcine a Celeron?
Basically look for what is different from your machine and the customer's mahine. This might tell what the problem is.
The Crazy One
Is the CPU on the customer's mahcine a Celeron?
Basically look for what is different from your machine and the customer's mahine. This might tell what the problem is.
The Crazy One
ASKER
The processor is a Pentium III same as mine (700mhz & 750mhz)
The operating systems are both Windows XP Pro.
The operating systems are both Windows XP Pro.
Hi accurates,
try to run different task instead of your application, may be it will be slow again. I mean that problem may be not in your app but in computers configuration. Something like realtime antivirus or something else.
-----
Igor
try to run different task instead of your application, may be it will be slow again. I mean that problem may be not in your app but in computers configuration. Something like realtime antivirus or something else.
-----
Igor
Hello,
Make sure you use FindKey instead of Locate(if your using this search) . FindKey will utilize the indexes for faster search , while Locate will not.
Delphi Help has code snippets on how to use FindKey.
Make sure you use FindKey instead of Locate(if your using this search) . FindKey will utilize the indexes for faster search , while Locate will not.
Delphi Help has code snippets on how to use FindKey.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Mike, I belive you helped me solve it.
What was the answer? I have remotely diagnosed this problem and have never had the luxery of personally having such a laptop at hand.
Thanks!
MP
Thanks!
MP
What I mean to say is that I have an outstanding problem with my product which I have not been able to solve because I can't personally interact with any of the problem machines since they are spread around the world...
Knowing exactly how you got around it would help me very much because then I can e-mail some instructions to these various people for them to try. Or maybe there is a change I can make in my app to turn the feature off while my app is busy.
Thanks!
MP
Knowing exactly how you got around it would help me very much because then I can e-mail some instructions to these various people for them to try. Or maybe there is a change I can make in my app to turn the feature off while my app is busy.
Thanks!
MP
ASKER
Hi Mike,
I disabled the Intel SpeedStep on the laptop and it sped up to what mine was searching at.
It is something to do with the Speed Step applet that was running on the machine, when I disabled it, the program ran like I thought it should.
Thanks again!
I disabled the Intel SpeedStep on the laptop and it sped up to what mine was searching at.
It is something to do with the Speed Step applet that was running on the machine, when I disabled it, the program ran like I thought it should.
Thanks again!
Thanks for the info!
MP
MP