SQL performance

[mikeh@minivend.com]

******    message to minivend-users from mikeh@minivend.com     ******

Dear All,

This has been a constant issue. MiniVend falls short in many ways
from what it maybe should be for SQL. I have not had the incentive;
but now with so many people using SQL I should probably bite the
bullet. A full rework will wait for a later version; the immediate
priorities will be st=sql and [sql type=list ...].

I will tell you it is not because of search speed. MiniVend will beat
any SQL database I know of if used properly.

It is because of DB access speed. I sort of thought people would use
embedded Perl for performance, but I did this a long time ago.  In some
ways I am a victim of the success of MiniVend's tag language. It is,
and my own use bears it out, much easier to deal with [sql type=list
query="select * from whatever"] than anything else.

Here is what I propose to do:

	1. Change the [sql type=list ....] to return a hash-based
	reference. This will be easy to do, I think, but there is 
	a possibility of some incompatibilities when making queries
	of databases that have multiple identical keys. I think it
	might be possible to default to the old behavior with a
	flag in that case.

	2. Change the st=sql to do the same thing.

	3. Do some testing to verify that it works. Obviously I will
	need help in this department from you all.

I will be holding the release of MV3.12 for this.

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
                                    131 Willow Lane, Floor 2  | ||  _ \
It's a little-known fact            Oxford, OH  45056         | || |_) |
that the Y1K problem caused         <mikeh@minivend.com>     |___|  _ <
the Dark Ages. -- unknown           513.523.7621 FAX 7501        |_| \_\
-
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