>I've installed a MSDE and connect a VFP table with using sp_addlinkedserver with OLEDB.
>
>Testing the performance I was surprised how slow this solution was. Since this table is not a big deal for VFP itself (cca. 25000 records) I thought it would be same with MSDE and I tested it on local PC.
>
>SELECT * FROM MyTable
>
>finished directly in VFP in 0 seconds (well, almost). I exported this table to a MSDE database and made a SQLConnect with ODBC. Creating Cursor with SQLExec takes about 4 seconds, what is acceptable in some way, but...
Your comparison is incorrect. In VFP you get filtered cursor which doesn't take any time to crerate regardless of the size of table. ou should add NOFILTER clause in VFP
SELECT * FROM MyTable NOFILTER
Anyway, access through ODBC driver or OLE DB Provider will always be slower than native VFP access. The more record you retrieve the longer it'll take. It's important to design your application in such way that it newer retriev huge amount of records.
<snip>
--sb--