Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Are Tables Faster than Queries?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00461772
Message ID:
00461779
Views:
14
Do you have a DELETED() tag on the table, and SET DELETED ON?

And you are correct, a VIEW will not be of any help.

>My query to a 300,000+ record table is taking too long for my app (5 sec) - especially since when it's published it'll be pulling the table from another machine so it'll be even slower!
>
>The table is linked to other applications maintained by the client, so I cannot make structural changes - but it seems like the indexes match the query.
>
>I'm sure I could tweak syntax a little, but I was wondering if I could speed things up by creating a VIEW instead. I suspect the answer is NO (what's a view, other than a remembered query, anyway). Please let me know if I'm wrong in my thinking.
>
>I figure I'll probably copy a subset of the data to a local table for faster initial display, and let it take the additional time needed for drill-down queries.
>
>Any other suggestions?
>
>TIA
Chris McCandless
Red Sky Software
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform