osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

How can I speed up the searching of products?

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 ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Installation issues

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 11-17-2005, 06:29 PM
New Member
 
Join Date: Nov 2005
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 0
Goweb
Default How can I speed up the searching of products?

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 11-24-2005, 10:55 AM
jpf's Avatar
jpf jpf is offline
Moderator

 
Join Date: Sep 2003
Location: Manitoba, Canada
Posts: 1,808
Thanks: 5
Thanked 105 Times in 91 Posts
Rep Power: 12
jpf is a name known to alljpf is a name known to alljpf is a name known to alljpf is a name known to alljpf is a name known to alljpf is a name known to all
Default RE: How can I speed up the searching of products?

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!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 11-24-2005, 02:50 PM
New Member
 
Join Date: Nov 2005
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 0
Goweb
Default RE: How can I speed up the searching of products?

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -8. The time now is 02:46 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax