Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

creating indexes in your sql database


Guest

Recommended Posts

Posted

i just installed a contribution the other day that suggested i put an "index" in one of the sql tables to speed up load time.

 

could i do this in the rest of my shop? how could i go about doing it throughout the entire database?

Posted

Depends on what the table is. Indexes speed up SELECT statements because they offer a quick way to look up information and match rows for a query. However, they slow down INSERTs because they require additional disk operations and sorting. And an index that isn't optomized for a query gains you nothing in a SELECT statement and only slows down INSERTs. So just indexing everything in site gets you nowhere and can slow everything down more.

 

What was recommended to be indexed?

Contributions

 

Discount Coupon Codes

Donations

Posted
i just installed a contribution the other day that suggested i put an "index" in one of the sql tables to speed up load time.

 

could i do this in the rest of my shop? how could i go about doing it throughout the entire database?

You may also want to check this thread.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...