>>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. >> >>Thanks >>Andy Roth >>Neyenesch Printers >>619 297 2281 >>andyroth@electriciti.com > >Can you be more specific please? How much records are you retreiving? What >is the DB? > The files are Btrieve(*.BTR) and I am not aware of any index files in the directory.The record count is around 1,000. Andy Roth Neyenesch Printers 619 297 2281 andyroth@electriciti.com