Re: [mv] *** MiniVend SQL Concept ? ***

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting Marc Aubert (maubert@swisscenter.ch):
> 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).

I hope you picked Interchange instead of Minivend. Minivend 3 is no
longer supported and should never be used for a new project; Minivend
4 is really now Interchange.

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

It depends on what you want to do. You don't include any code, so
it is hard to see what you *are* doing. If you are using the demo 
pages on a large database, you might not do well. But we don't even
know what demo you are using, if any.

Just like SQL queries, MV queries can be slow or fast. MV wants to give
more search granularity than SQL can provide, so it does do that. But
there are ways to do things differently.

If you use this search:

[loop search="
		co=yes
		st=db
		sf=category
		se=Hammers
		op=eq
		
		"]
[loop-code]
[/loop]

then look at the query logs you will see a difference.

You can access any SQL you want with:

[query list=1 sql="SELECT whatever FROM whereever WHERE foo = 'bar'"]
    [sql-code]
[/query]

So you can go fast or slow, depending on what you want. 8-)

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <heins@akopia.com>

Friends don't let friends use Outlook. -- Bob Blaylock
-
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