>>I am using the SQLEXEC() to select all records from a Btrieve table >>into a cursor. The speed at which it runs is not acceptable. 45sec - >>1.5 min. to load the cursor over a Novell 3.12 network. The syntax >>used is: >>lnHandle =SQLSTRINGCONNECT('DRIVER={Pervasive Software ODBC-32}; >> DDFPATH=G:\Macola\data;') >>lnResults=SQLEXEC(lnHandle, SELECT FROM >>ARVENFIL','vendors') >> >>Any ideas on who to speed this up or a faster approach. > >How many records are returned? and is the database index on the field. > Record returned are around 1,000 and the Btrieve files are not indexes to my knowledge. I can not find a index file in the directory. Andy Roth Neyenesch Printers 619 297 2281 andyroth@electriciti.com