indexing osc

[davidstummer]

as i will have millions of rows in the following tables in mysql (oscommerce), i need to index them to make searches faster. what i am asking for is for someone to run through how to do this in phpmyadmin. the follwoing tables and rows are affected

products table
products_desciption table
products_to_catergories table

i really don't have a clue how to do this to make it faster

please can some really nice person help out

cheers

dave

[jason]

If you are using the tables that OSC sets up automatically, I'd imagine they'd be indexed already. Any good database desgner would have indexed any fields that are searched on to begin with.

To check, log in to your CPanel, click on phpMyAdmin and then select the OSC database. Next, select a table from the list at the left on the window. Scroll down below the scructure table at the top and you'll see an indexes table that lists all of the indexed fields. If things aren't indexed that should be, you can index them by simply clicking on the index link next to the field you wnat to index in the top structure table. Note that indexing increases the size of your tables and if you "over-index" your tables you may actually slow them down more.

My guess (I've never used OSC) is that everything is indexed as it should be already. If it isn't running fast enough, it is probably a limitation of OSC, MySQL, or the server you're on.

--Jason