[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
[mv] *** MiniVend SQL Concept ? ***
Title: *** MiniVend SQL Concept ? ***
Hello,
We are very worried because our team has recently decided to
standardize on MiniVend for a huge swiss e-commerce project. The
database contains 50'000 items that are updated everyday (hosted on a
dual Pentium III 800 mhz RedHat 7.0 machine).
To gain maximum database security (transactional security), we
have chosen PgSQL over MySQL. However, until now the database results
are really bad.
According to PgSQL logs Š
001130
22:28:41 17
Connect www@localhost on test_construct
17
Query select * from products
17
Query select fname from userdb where
username = 'interchange'
17
Quit
Š it seems to us that for a single standard search request
MiniVend makes a 'SELECT * from products' and then sorts the results
through PERL. Are we right or totally wrong ? If this is true,
we cannot see how the whole thing could be efficient in term of
speeds. Without MiniVend, most of the requests take less than 0.5
seconds (even really complex ones). With MiniVend, results are awfully
slow.
Thanks for any answer. We really hope we missunderstood the whole
thing !
Mark
