Re: [mv] mySQL Database

["Christopher P. Lindsey" <lindsey@mallorn.com>]

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

Don't know if that will help or not, but it sounds vaguely appropriate.

Chris (the other one)
-
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