Hi Rob!
Am Don, 2004-12-23 um 18.54 schrieb Rob Keeling: > I have a 152MB MyISAM table that I am trying to execute a simple select > statement on, > I need to retreave all rows with a given index, sorted by date. > > This is taking a very long period of time to execute. Can you give the time a bit more exact? > > What can I do to speed up the query. You might tell us the exact table definition, and that of any indexes you created. > > The sql is, > > SELECT * FROM table WHERE (person_id LIKE 10) AND (session_start > > '2004-09-01 00:00:00') AND (session_start < '2004-10-01 00:00:00') Order by > session_start How would you define the "likeness" of numbers? Even though this seems to work for you, I would always code a numeric comparison with a numeric operator: person_id = 10 HTH and Merry Christmas, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
