Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid vs Browse
Message
De
25/11/1997 16:09:04
 
 
À
25/11/1997 15:57:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00062233
Message ID:
00062263
Vues:
37
>I don't know what is the reason, but you coud try it from command window using your own field/table names:
>USE H:\vfp_cue\cue\dbf\TITLE.DBF && this is 950K rec table
>_screen.addobject("grid1","grid")
>_screen.grid1.visible=.t.
>_screen.grid1.columncount=3
>_screen.grid1.recordsourcetype=1
>_screen.grid1.recordsource="TITLE"
>select title
>set filter to ttl_name="A"
>_screen.grid1.refresh
>set filter to ttl_name="B"
>_screen.grid1.refresh
>It works without any delays on my machine.

I tested this code and it is as slow.

What I tested is this:

USE N:\INFOPLUS\DATA\INFOLIST\ACRONYM
_screen.addobject("grid1","grid")
_screen.grid1.visible=.t.
_screen.grid1.columncount=3
_screen.grid1.recordsourcetype=1
_screen.grid1.recordsource="acronym"
select acronym
set filter to upper(acronym)="ABEND"
_screen.grid1.refresh

I have 350,000 records. SET OPTIMIZE is on as well as SET DELETE. The result gives 80 records.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform