Re: [mv] SOLVED mySQL Database

["Christian J. Müller" <cmueller@polinet.ch>]

******    message to minivend-users from "Christian J. =?iso-8859-1?Q?M=FCller?=" <cmueller@polinet.ch>     ******

"K. Joch" wrote:
> 
> ******    message to minivend-users from "K. Joch" <k_joch@yahoo.com>     ******
> 
> >>>>>>>>>>>>>>>>>> Ursprüngliche Nachricht <<<<<<<<<<<<<<<<<<
> 
> Am 25.01.00, 16:22:44, schrieb "Christopher P. Lindsey"
> <lindsey@mallorn.com> zum Thema Re: [mv] mySQL Database:
> 
> > ******    message to minivend-users from "Christopher P. Lindsey"
> <lindsey@mallorn.com>     ******
> 
> > > I still cant believe that MV would want to use 413 MB of DRAM simply
> to
> > > load the mySQL db.
> > >
> > > MV is idle and the catalog page is not even showing yet. Why should MV
> > > use that much memory?
> > > This is not a MEMORY database. If the data of my dbs was all in MV,
> then
> > > I do not need SQL to access a external SQL db.
> > > The mySQ db uses some 230 MB disk space and MV uses 413 MB DRAM!
> 
> > I did a quick search in the minivend mailing list archives and came
> > across this message from Brian Bullen in 1998:
> 
> >    http://www.minivend.com/minivend/minivend-list/1998-old/0068.html
> 
> >    I hit a performance problem with a 75000 record products file.
> >    Minivend took forever to start, and it was clear the minivend
> daemon
> >    was hogging memory (about 20meg).
> 
> >    The resolution was to use the "Database .. NAME" config
> specification to
> >    identify to minivend the database field titles -- now minivend
> starts
> >    immediately - also (I have noimport specified).
> 
> >    catalog.cfg lines:
> >    Database products products.asc dbi:mSQL:minivend:localhost:1114
> >    Database products COLUMN_DEF code=char(10)
> >    Database products COLUMN_DEF price=char(6)
> >    Database products COLUMN_DEF description=char(64)
> >    Database products NAME code price description
> >    # currently, load products database independently of minivend:
> >    NoImport products
> 
> There is a select * from <table> in the code witch caused my db with
> 500.000 titles to need 45 min for startup. Patching the select with
> LIMIT helps out. Anyway enabling glimpse makes sence, because searching
> in sql is not as fast as needed.
> 
> Best regards,
> 
> karl
> karl@kmj.at
> 
> > Don't know if that will help or not, but it sounds vaguely
> appropriate.
> 
> > Chris (the other one)

Thanks Karl and Chris (the one, but not only).
This certainly solved the problem. MV starts instantaneously now and
uses only 12 MB DRAM instead of the 412 MB before!. This should be
covered in the docs under the NAME attribute. The text there is very
vage in this respect.
I can now start buildng the catalog (and saved some bucks for DRAM).
Chris
-
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