> But on ODBC these databases are extremely slow. It will take
> like 2000 ms to query a table that has NO records in it. I
> have one live site running, with minimal traffic, and it uses
> Access with OLEDB and runs large queries in 30 to 500 ms or
> lower. Plus at work, ODBC Access databases run on an equivalent
> machine just fine. It's not just Access that is slow. Any ODBC
> database I create runs at a snails pace. Is there any reason
> why the ODBC stuff would crawl but OLEDB runs normally?
Have you updated your version of MDAC to one of the later versions?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists