Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with browse on new computer.
Message
From
19/05/2001 01:32:14
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
 
 
To
18/05/2001 16:58:01
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00508986
Message ID:
00509052
Views:
20
>We have a Dual Processor Pentium 733, working in Windows 98.
>When we perform complicated condition Browse on a large Databases, computer locks.
>File pack/reindex is slower on this machine, than single pentium 3 600.
>May be, somebody had similar problems?

First of all, running Windows 98 on a dual processor machine is a waste - W98 can make use of only 1 processor. Having said that, a single PIII/733 should still be faster than a single PIII/600.

If the tables are much larger than RAM size, speed of many database operations will depend more on disk speed than CPU speed. Maybe the 600MHz machine has a fast SCSI disk subsystem. Or, are both machines accessing tables on a server? In that case network speed may be an issue.

Service Pack 3 of Visual Studio 6 improved REINDEX speed a great deal on large tables. Make sure you are using at least that level, preferably the current Service Pack 5.

Rather than BROWSEing a large table, you could try a SELECT - SQL into a smaller cursor, and BROWSE that.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform