Re: postgres slowness

[Chris Powell <helios@brickandivy.com>]

******    message to minivend-users from Chris Powell <helios@brickandivy.com>     ******

> I'm currently experiencing undesirable slowness when using Minivend to
> access a postgres database, and I'm wondering if others have also run
> into this issue and dealt with it successfully. 

Mark,

I, too, found myself experiencing this but got things fixed.  I have a 
Solid SQL backend that Minivend employs.  Now, before I went to the SQL 
database I just used Minivend's internal mechanism -- things were snappy. 
 Then I migrated to the database backend and things bogged down.

I believe that the slowdown lies in the DBI / DBD overhead, but I did 
find a speedup (either accidentally or by simply getting the .cfg syntax 
correct. :)  Here is a relevant snip from my catalog.cfg:

 Database            products    products.asc      SQL
 Database            products    DSN               DBI:Solid:upipe 
MYSOLIDDB

What this does is employ the Solid SQL backend as the master database of 
products, but Minivend also updates the products.asc file and keeps it 
current.  It's my understanding that Minivend then uses the .asc file for 
most of its work -- a lot faster due to less overhead -- while keeping 
the .asc file in sync with the "real" products database.

Regards,
Chris

-- 
Christopher Powell               Brick and Ivy Corporate Consulting
helios@brickandivy.com                  http://www.brickandivy.com/

                    finger for PGP public key
              talk helios@hexagram.brickandivy.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