[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Four thousand items -> slow
****** message to minivend-users from Viktors Rotanovs <viktors@riga.nu> ******
Hi,
the problem could be that AFAIK minivend first fetches all rows and then
sorts 'em. Better pass sql query directly to the server and then use results,
because sql server is written in C and thus will sort much faster than
mv itself. Also, making one query per product is very expensive,
try to make query count independent of product count.
On Mon, 24 Jul 2000, you wrote:
> ****** 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
--
Best Wishes,
Viktors Rotanovs
I create websites that attract more clients. http://riga.nu/
Riga Latvia +371, Phone 7339-622, GSM 9173-000, FAX 7377-472
-
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
