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]
