Guest Posted December 9, 2005 Posted December 9, 2005 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?
kgt Posted December 9, 2005 Posted December 9, 2005 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
user99999999 Posted December 9, 2005 Posted December 9, 2005 Try this in your search and you will find some. "alter table categories add index"
Guest Posted December 11, 2005 Posted December 11, 2005 What was recommended to be indexed? this contribution: http://www.oscommerce.com/community/contri...search,inactive "I recommend to set an index in the table 'orders' on the column 'customers_id'. Without this index the SQL query is very slow (because of the join of the two biggest tables in the database)"
Guest Posted December 11, 2005 Posted December 11, 2005 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.