Here are some numbers from some further testing.
Hardware: Pentium 2 350, 64M RAM.
Network: NT4.0 SP? (I am not the administrator)
As below: Test from Command window:
1. use blah
2. go bott
3. brow
Slow speed happens in brow
IN VFP.
Table has 96,000 records. Indexes on 6 of 12 fields.
Test 1: Nothing open.
Brow took 0:27 to fully open.
Test 2: Open DBC first.
No effect on browse time.
Test 3: Open an FWP2.6 table. 250,000 records.
Browse took 1:07!!! to fully open.
In FPW 2.6 Test 3: table open instantly.
Any ideas?
TIA,
Mike
>>Can anything be done to increase the speed of fox opening tables, and navigating them?
>>
>>In FPW 2.6 command window,
>>use blah
>>go bott
>>brow
>>works very quickly.
>>
>>The same set of commands in VFP are quite slow, i.e. 15 secs.
>>
>>Any ideas?
>>
>>TIA,
>>Mike
>
>Sounds strange to me! I have a table with a million records, it opens in a blink of an eye. Post the exact commands, index available, how many records?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement