Search found 1 match

by mopoke
Wed Aug 03, 2011 4:43 am
Forum: Bugs, bug fixes & releases
Topic: Long-running query against customer table
Replies: 1
Views: 3044

Long-running query against customer table

From time to time we'll notice a long-running query on our database server which looks like this: SELECT count(*) FROM ( select cust.customer_id, cust.gender, cust.firstname, cust.lastname, cust.email FROM customer_1_tbl cust ) agn Typically this will take some minutes to complete (there's around 60...