RE: SQL performance

["Jeff Carnahan" <tails@dakotacom.net>]

******    message to minivend-users from "Jeff Carnahan" <tails@dakotacom.net>     ******

Mike, one thing I've been looking for lately and have been frustrated with
is the lack of [on-change .. /] support within a [loop ... /] enclosure...
This would be helpful for working with in-page searches courtesy of [loop
search=" ... " ... /]...

Will 3.12 allow the use of [on-change ... /] within in-page searches as
well as within the [search-results .. /] tag?

--
Jeff Carnahan
tails@dakotacom.net

-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of
mikeh@minivend.com
Sent: Tuesday, February 09, 1999 8:27 PM
To: MiniVend User List
Subject: SQL performance


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


-
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