General Blather

My Simple Blog
« Put on the Spot: Biggest Hack?Long Overdue Server Reassignment »

Query So Slow

Permalink 02/22/10 22:51, by Jeff, Categories: Blather , Tags:

Running a query to trim database to records just in last 30 days. Cutting too much times out, so trimming from long ago to less long ago. Query for four months ago took 90 minutes. Query for three months ago still churning ten hours later.

No feedback yet

Leave a comment


Your email address will not be revealed on this site.

Your URL will be displayed.
PoorExcellent
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)
February 2012
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29      

General Blather

Just some random blathering and thoughts.

Search

Ad From Google

XML Feeds

What is RSS?
powered by b2evolution free blog software

©2012 by Jeff Warren

Contact | Help | Blog skin by Asevo | blog software | web hosting | monetize