[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Optimize Database
****** message to minivend-users from Jerry Bransom <jbransom@pcpc.data1.com> ******
> Hello All,
> I have recently added a large database to one of my sites. It has 2
tables, one for basic product information and the other for very
specific, in-depth product information. The first table the products.asc
file is 7 MB, but the second table is over 100 MB. Does anyone have any
suggestions on ways to optimize this, speed up searches etc.
More CPU is my best suggestion. It seems less costly.
>
> Secondly, what is the best way to access the information in the
second database? What I would like is to have a button for more info on
the flypage, and have only information from the products.asc on the
flypage, and all the extended information on the second page.
>
HMm .. one of the more experienced will have to help with this one.
> Last, I have never had success implementing the mv_max_matches
directive for a search. I have it set to 250, because the database has
75,000 products and it takes perl too long to generate an html response
to that. Nonetheless, if I search for something, it will return more than
250 results.
I changed my MaxHits directive to 10 in the Search.pm module. You may
need to do a better job of categorizing your products.
WHen you are dealing with such large databases, it is pretty hard to
deal with it. We limit all of our databases to only 300 products.
The fact is, only a few things will actually ever sell on the Internet.
The customer has to realize this and you as an administrator have to
be careful. Even the IBM Mainframes have trouble querying 75,000 records.
How can you expect a PC or Sparc to do any better?
The opinions expressed are my own. Love to hear other thoughts.
*****
Jerry Bransom
Sr. Programmer Analyst
Kern Internet Services
www.calmarket.com
www.kern.com
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
