Re: Setting up and running mySQL on a unix server

2001-08-15 Thread Dan Makovec
Most likely very hard, if you don't RTFM first :) d - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 15, 2001 11:40 PM Subject: Setting up and running mySQL on a unix server > How easy/hard is it install and run mySQL on a unix server? > >

Re: SELECT MIN(field) takes minutes on a large table!

2001-08-14 Thread Dan Makovec
timize index/query etc. > and that you cannot always throw hardware > at a problem, but wanted to toss that out as a possible > reasonable short term solution for Dan. > > BTW, mysql runs the same query on that 1G desktop > in 7 seconds or 3 seconds faster than Microsoft's SQL

SELECT MIN(field) takes minutes on a large table!

2001-08-13 Thread Dan Makovec
Hi folks, Wondering if anybody can help me with this one. I've got a table with 6.2 million rows in it, and MySQL seems to be straining a bit with it. It's a basic table storing stock trading prices: ++-+--+-++---+ | Field | Type| Null | Ke

Help querying a simple but large table

2001-03-15 Thread Dan Makovec
Hi all,   I'm having problems getting reasonable speed queries from a simple table.   First, a little info about my server setup:   From mysqladmin version: mysqladmin  Ver 7.11 Distrib 3.22.27, for -free