This is a discussion on How can I speed up the searching of products? within the osCMax v2 Installation issues forums, part of the osCMax v2.0 Forums category; I have a rather larger product listing (97,000 items). When I do a search for an item type, the search ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| I have a rather larger product listing (97,000 items). When I do a search for an item type, the search process takes a long time. Any way to increase the search result time? URL to site: www.digitalcheap.com |
| Sponsored Links | ||
| ||
|
#2
| ||||
| ||||
| Create indexes....PM sent!
__________________ JPF - osCMax Fourm Moderator Try out our osCMax at: Live Catalog Demo Limited access Admin: Live Admin Demo Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped! |
|
#3
| |||
| |||
| This is what I was told from my programmer - If you have any thoughts or ideas please let me know. Thanks!! ------ Info from my programmer ------------- No. It will not help. Search in OSC cannot use any indexes Only can use FULLTEXT index, but this index type do not work on you OSC tables.. All tables type is MyISAM... Fulltext search require InnoDB tables. I will try to make both type tables on my local server with you OSC DB and try to run some queries on it for performance checking. |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| new products-link show all products, not 10 as I configure.. | mikkvais | osCommerce 2.2 Discussion | 0 | 08-23-2005 02:31 PM |
| Searching in admin for Products Model | modMan7 | osCMax v1.7 General Mods Discussion | 2 | 02-19-2005 06:30 PM |
| Searching Manu Turns up 0 | horsewhip | osCommerce 2.2 Modification Help | 1 | 09-01-2004 09:26 AM |
| SPEED things up? | dragon5 | osCommerce 2.2 Modification Help | 3 | 07-05-2004 08:06 AM |
| Speed Issues... | spectrumpower | osCommerce 2.2 Modification Help | 2 | 06-08-2004 11:44 AM |