Re: [mv] mySQL Database

["K. Joch" <k_joch@yahoo.com>]

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




__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.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