Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexes on Remote Views
Message
From
02/04/2007 22:01:07
 
 
To
02/04/2007 21:57:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01211442
Message ID:
01211556
Views:
15
And don't forget, that if your tables get over 2gigs, you can't pull all the records down to a cursor anyway -- nor should you try. You have to get away from anything that depends on all records being in the cursor unless the table sizes are small enough to requery often to keep the data fresh -- and in that case, why move to SQL Server?
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Reply
Map
View

Click here to load this message in the networking platform