Macromedia's site, which do not really apply to MS Access but it couldn't
hurt. We have an application that requires a large recordset to be returned
(~10000 records), CFQUERY caching helps somewhat but the problem exists
whenever the cache is cleared.
I think that Access just cannot handle the load, the ODBC Server hangs
first, then CFMX Server. When I notice the spiking, I restart CFMX Server
first, then the ODBC Server and finally the ODBC Client in that order, that
prevents me from rebooting the entire server. Nothing I have tried has
really helped other than employing my own caching strategy using Application
variables, but the dataset is so large that Access chokes. I will be moving
the app over to MySQL pretty soon but I was holding out for MySQL 4.1 to be
released in full before I do so because we have some queries with subqueries
that cannot be rewritten.
Donnie Bachan
Phone: (718) 217-2883
ICQ#: 28006783
"Nitendo Vinces - By Striving You Shall Conquer"
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
