Find out the real way: Use EXPLAIN and BENCHMARK() commands to get the speed of your operations with and without an index. That's the only way to know for certain.
Cheers, Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. - Yogi Berra --- > -----Original Message----- > From: Dan Anderson [mailto:[EMAIL PROTECTED] > Sent: Monday, December 15, 2003 1:18 PM > To: Chris Elsworth > Cc: [EMAIL PROTECTED] > Subject: Re: Questions about indexing > > > > With such a small database it really boils down to just being tidy; > > you don't want indexes you're not going to use. > > Well the database is going to be like 200MB and executing several > hundred queries a minute. Thus my concern about speed. Is a > P4 w/ 1GB > RAM going to choke and die, or will indexing help out? > > Thanks in advance, > > Dan > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] >
