[mv] Four thousand items -> slow

["Brian Klug" <bklug@indiapoint.com>]

******    message to minivend-users from "Brian Klug" <bklug@indiapoint.com>     ******

I'm hoping someone can help illuminate me as to what I'm misconfiguring.
I...

1. Freshly installed Interchange V4.5.3 on linux 2.0.36 (rh5)
2. Setup 'simple' catalog with mysql server 3.23.3-alpha
3. Added 4000 products to The Art Store
4. Added the following line to ~/catalogs/simple/mysql/products.mysql:
	Database  products  COLUMN_DEF  code=char(16) PRIMARY KEY
5. Restarted minivend, no errors in catalog/minivend/apache logs
5. But pages still load slow, such as admin/items which contain:
	<select name="item_id" size=10>
	[loop search="
        fi=products
        st=db
        ra=yes
        ml=9900
        tf=description
        rf=sku,description
	"]<option value="[loop-code]"> [loop-param description]
	[/loop]
	</select>

It isn't sorting, so I'm not sure why it takes 2 min+.  Minivend swells
up pretty large too,

  PID USER     PRI  NI  SIZE  RSS SHARE STAT  LIB %CPU %MEM   TIME
COMMAND
29998 mvend     20   0 31772  29M  8040 R       0 74.7 46.9   3:03
minivend

Is 30 megs of memory usage normal for a simple select statement?  Hard
to tell without knowing the inner workings of mv.

I developed my own perl/DBI shopping cart system for another site which
has 15,000 products.  Same hardware -- that is why I'm a little
frustrated.  I'm looking to minivend because I the company owns the code
I wrote, plus I'd like to contribute to open source development.  

Thanks
Brian
(test config: mvend.dustball.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