Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid vs Browse
Message
From
25/11/1997 16:09:04
 
 
To
25/11/1997 15:57:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00062233
Message ID:
00062263
Views:
32
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform