Estimating Query Performance

2004-09-09 Thread Matthew Boulter
G'day all, I was hoping to leech from your amalgamated knowledge: I've been asked to estimate the query performance of several SQL queries that power our Reporting system. At the moment we're preparing to scale up enormously the amount of data we're using in our system, and therefore I'm trying

Converting char data ISO8601 to Unixtime Error

2003-12-12 Thread Matthew Boulter
Afternoon all, This is an interesting problem that we ran into and have subsequently fixed (well it fixed itself, but more on that later). I posted a question to the list a couple days ago quoting this as a TIMESTAMP(14) column type issue, but as I investigated more, that turned out to be

Strange Timestamp behaivor

2003-12-10 Thread Matthew Boulter
I have just started noticing some bizarre behaivor in tables in our database that contain a TIMESTAMP(14) field. I only shown a small query, but it highlights the error: mysql SELECT ErrorTime FROM ErrorLog WHERE ErrorTime = 20031210063712; ++ | ErrorTime |