Also have a look at the logs is there anything else going on on the server?
kola >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] >> Sent: 31 July 2003 12:22 >> To: [EMAIL PROTECTED] >> Subject: Re: [ cf-dev ] slow queries >> >> >> I'll give it a go. The site seems to be working fine, just now, so not >> sure if I'll be able to tell if that's fixed it. >> >> >> ta >> >> >> Duncan Cumming >> IT Manager >> >> http://www.alienationdesign.co.uk >> mailto:[EMAIL PROTECTED] >> Tel: 0141 575 9700 >> Fax: 0141 575 9600 >> >> Creative solutions in a technical world >> >> ---------------------------------------------------------------------- >> Get your domain names online from: >> http://www.alienationdomains.co.uk >> Reseller options available! >> ---------------------------------------------------------------------- >> ---------------------------------------------------------------------- >> >> >> >> "Tom Smith" >> <[EMAIL PROTECTED] To: >> <[EMAIL PROTECTED]> >> hoo.co.uk> cc: >> Subject: Re: [ cf-dev ] >> slow queries >> 31/07/2003 >> 12:19 >> Please respond >> to dev >> >> >> >> >> >> have you tried to compact and repair the database, and see if that helps? >> ----- Original Message ----- >> From: <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Thursday, July 31, 2003 12:05 PM >> Subject: [ cf-dev ] slow queries >> >> >> > Got a site with an Access database, CF 4.5. Intermittently, some pages >> > will take a long time to do any queries on the page. It's a site in >> > development so it's not exactly getting many hits. Other times all the >> > queries run in the sort of time you'd expect. When it's slow, it's >> taking >> > around 1 - 5 seconds per query. When it's normal, it's more like 10 - >> 30 >> > milliseconds. >> > >> > Queries are fairly simple stuff, e.g. SELECT ID, Name From Table Order >> by >> > Name, taking upwards of 2 seconds! All the tables are very small, just >> a >> > handful of rows in each. >> > >> > As it's intermittent I haven't figured out if it's particular queries, >> > tables or pages, but I'm pretty sure it's happening on all the tables, >> on >> > any page. >> > >> > why would this be, and how can it be fixed? >> > >> > >> > Duncan Cumming >> > IT Manager >> > >> > http://www.alienationdesign.co.uk >> > mailto:[EMAIL PROTECTED] >> > Tel: 0141 575 9700 >> > Fax: 0141 575 9600 >> > >> > Creative solutions in a technical world >> > >> > ---------------------------------------------------------------------- >> > Get your domain names online from: >> > http://www.alienationdomains.co.uk >> > Reseller options available! >> > ---------------------------------------------------------------------- >> > ---------------------------------------------------------------------- >> > >> > >> > >> > -- >> > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ >> > >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> > For additional commands, e-mail: [EMAIL PROTECTED] >> > For human help, e-mail: [EMAIL PROTECTED] >> >> >> -- >> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> For human help, e-mail: [EMAIL PROTECTED] >> >> >> >> >> >> >> -- >> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
