Re: [mv] mySQL Database

[Birgitt Funk <birgitt@booktraders.com>]

******    message to minivend-users from Birgitt Funk <birgitt@booktraders.com>     ******




On Tue, 25 Jan 2000, Christian J. [iso-8859-1] Müller wrote:

> > 
> > Are you saying you have 90 fields in your products table?  If you access
> > just a handfull all the time and the rest rarely you might want to
> > think about splitting it apart.
> 
> Yes it has 90 fields. The reason being that I am getting this file as is
> and it is updated dayly/weekly. For reasons of data integrity, I chose
> to keep all fields, whether or not they are needed.
> 

Lucky you. 8-)

> > 
> > Look also at your mySQL logs to see just how that is starting up and the
> > kinds of queries.  Indexing makes a huge difference in SQL performance.
> > 
> 
> The mysql log just shows that mv it making a select * query on all
> tables. Thats all. Nothing unusual.
> I havn't gotten any further, since the system is so slow, it is unusable
> unless I add more memory. 
> 

Just a wild guess, but if you have an updated db read into MySQL on a
daily/weekly basis, why don't you export it weekly/daily into .gdbm, use
indexing and binary searches and static pages. At least that is fast.
But sorry, this is the way it was done in the old times with MV 3.8.

I guess nowadays it could all be done fast with sql searches.
Unfortunately I hadn't a chance yet to try it out. Let us know
how it is going. And let us know your site too and good luck with it. 8-)

Birgitt Funk
> 

-
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