Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Local view works VERY slowly
Message
From
15/04/1998 16:44:19
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Local view works VERY slowly
Miscellaneous
Thread ID:
00092293
Message ID:
00092293
Views:
57
I am using a grid based on local view.
Local view is based on table having many records and returns all the records.
Prb: Local view creation scans ALL the records from base table and
this works VERY slowly! So it is not possible to use local views
for large data manipulation!? Fetchsize works for remote views only.

If I use table-based grid instead of view, it appears immediately,
if there are many records returned from table. But when filter condition returns only a few rows, table-based grid causes FoxPro to
hang, but browse command works. Since there are many different queries, I cannot pre-build a index for table.
So it is not possible to use table-based grid also!

So, it is not possible to use grid control at all for large data manipulation!
Andrus
Next
Reply
Map
View

Click here to load this message in the networking platform