#-----Original Message-----
#From: Martin [mailto:kitten at psophos.com]
#Sent: 31 August 2000 00:13
#To: webdev at linux.ie
#Subject: Re: [Webdev] SQL question
#
<snip>
#To make the search quicker you could put an index on every
#column in the table. Not recommended though. Searching is nice &
#fast but inserting data is painfully slow as all the indexes
#must be updated too.
That's why you should really only set indexes on fields that you will search
on more frequently than not; the fields containing primary and secondary
keys
should definitely be indexed, anything else only if you absolutely have to.
Ken
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
