[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: SQL performance
****** message to minivend-users from "Alan Sparks" <asparks@nss.harris.com> ******
From: mikeh@minivend.com <mikeh@minivend.com>
>Price: <A HREF="[area order [sql-param 0]]"> [sql-param 3] </A><BR>
>
>[sql-param 0] is nothing but a synonym for [sql-code].
>
>The difference should be dramatic; perhaps I could give it named-field
>access though how to do that doesn't seem obvious to begin with.
I just tried that... doesn't seem to make an appreciable difference here...
>This tells me people are not indexing their databases. If you are
>using an SQL database it is YOUR responsibility to index the fields --
>if MiniVend is taking literally FOREVER to return stuff that tells me
>you didn't index your 'code' field. If you are not indexing at least
>the 'code' field, then the results are on your head. If you want
>fast searches, you must also index the rest of the fields you might
>be searching.
>
I figured that. I definitely have the ID fields (and a couple of others)
indexed. Figured I'd better double-check that before opening the can of
worms... :-)
>--
>Mike Heins http://www.minivend.com/ ___
-Alan
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
