>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