Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with browse on new computer.
Message
De
19/05/2001 01:32:14
Al Doman (En ligne)
M3 Enterprises Inc.
North Vancouver, Colombie Britannique, Canada
 
 
À
18/05/2001 16:58:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00508986
Message ID:
00509052
Vues:
21
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform