[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] *** MiniVend SQL Concept ? ***
****** message to minivend-users from cfm@maine.com ******
On Wed, Nov 29, 2000 at 09:11:14PM +0100, Marc Aubert wrote:
> 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).
That's not too terribly big and you have plenty of horsepower. I hope
a lot of RAM. Is this your first minivend catalog? What have you
tried for indexing? How about a URL?
>
> 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
> <mailto:www@localhost>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
--
Christopher F. Miller, Publisher cfm@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
1.207.657.5078 http://www.maine.com/
Content management, electronic commerce, internet integration, Debian linux
-
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
