RE: Time series

2004-01-01 Thread Schulman, Michael
ve is trying to do. Thanks again, Mike -Original Message- From: Fredrick Bartlett [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 10:12 PM To: Schulman, Michael; [EMAIL PROTECTED] Subject: Re: Time series Is Hour a DateTime? If so, will this work... SELECT ticker, DATE_F

RE: Time series

2004-01-01 Thread Schulman, Michael
: Thursday, January 01, 2004 9:57 PM To: Schulman, Michael; [EMAIL PROTECTED] Subject: Re: Time series Hmmm... First: select * from table1 order by field1 asc limit 1 Last: select * from table1 order by field1 desc limit 1 - Original Message - From: "Schulman, Michael" <[EMAIL P

Time series

2004-01-01 Thread Schulman, Michael
Hi, I work for a large financial instituition. We are currently evaluating databases to store intraday stock data. These are large tables with 40 million rows per day. We've done some initial testing with MySQL and have been extremely impressed with its speed and ease of use. I know that it go