>Hello all,
>My question: Since VFP handles its native DBF structure so well and with such speed, are there any plans by Microsoft to break the 2GB size limit of DBFs? ODBC and Oracle or SQL still seem way too slow. Any thoughts?
>
>Randy W Fogg
>DB³ Inc.
No, the 2 Gig DBF file limit will remain.
What do you mean by SQL being way too slow? I think its query performance is quite optimized. In terms of ODBC capabilities, I can have a VFP remote view to SQL Server pull thousands of records in a couple seconds. That seems pretty fast to me!
Tip: Try this technique to speed up remote views that return large result sets:
USE myview
GO BOTTOM
LOCATE
--OR--
SELECT MyView
REQUERY()
GO BOTTOM
LOCATE
That actually pulls the records faster by forcing synchronous execution or something.
Also, limiting the result set by an optimizable filter expression helps immeasurably.
-JT
Jeff Trockman, MCP