> 9 user tables, and data are normalized up to 3NF. I'm using
> CFMX 6.0 Prof. for Windows. I just did a quick test, query
> runing from Access's internal SQL command line/window, very
> fast, reasonably involved query (with three inner joins).
> The same app running on MS SQL Server 2000 is almost at
> lighting speed, so, the problem seems to be on the Access
> driver and connection to and from the CF server. Has anyone
> had similar experience?
There could be all kinds of reasons for this. You're going to have to narrow
them down a bit. What happens with newer Access databases? What version of
MDAC is installed? What happens when you query this Access database from
other ODBC clients, as opposed to running the query within the Access
database directly?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
