Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Takes too long to SEEK
Message
De
05/12/1997 19:49:55
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
05/12/1997 17:28:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00064114
Message ID:
00064195
Vues:
36
>
>Did you test with an index set on the table?
>
>Thanks for trying to help me diagnose.
>I have done some further testing myself.
>New form (base form). New grid (base grid)
>add table to DE (125,000 records, 86 fields) with order (this is important) set to main index
>set grid's datasource to table.
>added three buttons to the form:
>
>button1.click:
>temp = seconds()
>go top
>thisform.mygrid1.refresh
>thisform.caption = str(seconds()-temp, 5,2)
>
>button2.click:
>temp = seconds()
>go bottom
>thisform.mygrid1.refresh
>thisform.caption = str(seconds()-temp, 5,2)
>
>button3.click:
>temp = seconds()
>go 60000
>thisform.mygrid1.refresh
>thisform.caption = str(seconds()-temp, 5,2)
>
>clicking button 2 changes the form's caption to .04
>clicking button 3 changes the form's caption to .01
>clicking button 2 again changes the form's caption to .02
>clicking button 1 (go to top of table) changes the form's caption to 2.36
>
>Any idea what's going on? anybody?

I used an index set to ingrid search field. Without setting manually you should use Rushmore optimizable expressions and instead of go top and go bottom (these do it sequentially) use locate or seek "" (for go bottom use the index desc.).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform