Re: [mv] Four thousand items -> slow

["Nick Pleis" <npleis@saratogaweb.com>]

******    message to minivend-users from "Nick Pleis" <npleis@saratogaweb.com>     ******

I have a store that runs with pretty decent response times on a similiar
system (redhat 6.1). It currently contains roughly 776,000 entries or so.

The only difference is, I avoided the loop search syntax in favor of the
more natural (to me)
[query sql="select * from foo" list =1]
[/query]

which offers response times directly equal to what I get from straight
selects through standard DBI.

Nick
-----Original Message-----
From: Brian Klug <bklug@indiapoint.com>
To: minivend-users@minivend.com <minivend-users@minivend.com>
Date: Monday, July 24, 2000 2:51 PM
Subject: [mv] Four thousand items -> slow


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

-
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