Re: Creating index on very large table

2004-03-29 Thread Kyle Renfro
http://www.geocrawler.com/archives/3/8/2002/11/50/10245455/ Kyle - Original Message - From: "Jeffrey Horner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 29, 2004 12:05 PM Subject: Creating index on very large table > Hi folks, > > I've got a problem creating an index

Re: Creating index on very large table

2004-03-29 Thread Kyle Renfro
about an hour or so. You need the processlist to show "repair by sort" not "repair with keycache". I'm not an expert - but this worked for me. Kyle Renfro [EMAIL PROTECTED] - Original Message - From: "Jeffrey Horner" <[EMAIL PROTECTED]> To: &

Re: 6.5 seconds seems slow for the following search?

2004-03-28 Thread Kyle Renfro
On Sat, 2004-03-27 at 13:59, Dan Nelson wrote: > In the last episode (Mar 26), Kyle Renfro said: > > I am testing MySQL as a possible replacement for our proprietary db > > server for several large databases. I really want MySQL but I am > > getting what seems l

6.5 seconds seems slow for the following search?

2004-03-26 Thread Kyle Renfro
I am testing MySQL as a possible replacement for our proprietary db server for several large databases. I really want MySQL but I am getting what seems like slow search times. Does 6.5 seconds seem slow/typical/fast for the following search? SELECT main.ownername FROM main, rolledplate WHERE r