The more data u fetch the more time the query takes,.
Can u please check the explain plan for the entire month and lets us know.
If the number of rows processed by db is more than 10% of the total rows,
than optimizer considers doing a FULL TABLE scan better than a index scan
On 6/27/08, Darryl
can u please show use the content of the test.csv file. Also is comapny
name a single column or two different columns
If its two different columns than try this
load data file '/foo/test.csv' into table abc.test fields terminated by ','
(company,name);
On 6/28/08, bruce [EMAIL PROTECTED]
To find out more about Twitter, visit the link below:
http://twitter.com/i/429c961b36cd7c31a28772a32e82bb19f302ebaf
Thanks,
-The Twitter Team
About Twitter
Twitter is a unique approach to communication and networking based on the
simple concept of status. What are you doing? What are your
Hi Ananda,
At the moment the explain for the entire month will look the same as the one
I first gave as the database currently only has test data for the start of
the month.
I will populate the database with more info on Monday, but I have managed to
get it to return only the rows where the
Hi folks -
I've searched the web in vain to try to find anyone else with this
problem. My computer will intermittently start having all SHOW
FIELDS queries take 2 seconds. Not 1. Not 3. Always 2. The problem
appears suddenly for no apparent reason - sometimes immediately after
restarting the