I have a small Access 97 database (~2.5 MB), which has about 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?
You cann't say, use MS SQL Server 2000 then, you know client dictates what db to use.
Thanks.
Don Li
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
