A fairly normal problem with access, if it is a big database. If it is not a particularly big db, try doing a repair on it and see if that improves things, in which case you need to get your client to regularly do this. When a access database is regularly in use it tends to become bloated with crap and doing a repair optimises it. Of course on a shared host, you will have hundreds of other people on your server using access databases as well, and most of them will be using it beyond it's abilities and putting too many connections through it, which will be causing some problem for the CF ODBC service and for CF itself as it queues up all those connections. Best, don't use Access. Get your client to export the data to a CSV and import that.
Russ -----Original Message----- From: Mickael [mailto:[EMAIL PROTECTED] Sent: 09 October 2005 14:32 To: CF-Talk Subject: CF Query Timeout Hello, I have a unique situation that I only have limited control over. I was hoping someone on the list could provide some assistance. Here is my issue. A have a CF Site on a shared hosting account at Crystaltech. The database is Access. This was fine for a certain amount of time but now either there is too much activity on the shared box or the query are returning too much data that the CFQUERY timeout is becoming and issue. The data in access is being supplied from the client via FTP and the CF app accesses it. It is over written over night. I can change the way the client gives me the data it is an automated process. So I was thinking that I would mirror the exact tables in MS SQL then once a night select all the content from Access and insert it into SQL. Then have all my users access the SQL tables. Sounds logical, the only issue is that I can get the all the records to insert into the MSSQL database in a timely fasion. I keep getting the CFQERY timeout. Maybe its the way that I am doing it that is inefficient. I am using both DSN like so, <cfquery name="GetPayments" datasource="#request.AccessDsn#"> Select * from Client_Pmt </cfquery> <cfoutput query="GetPayments"> <cfquery datasource="#request.MSSQLDsn#" name="qry_insertPayments"> insert into Client_Pmt (Acct_id, PMT_Date,Pmt_Code,PMTAMT) Values (#Getpayments.DEBT_ID#, '#Getpayments.PMT_DATE#', '#Getpayments.PMT_CODE#', #Getpayments.PMTAMT#) </cfquery> </cfoutput> Is there a better way to do this? Thanks Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220504 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
