[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: SQL performance
****** message to minivend-users from "Walt Lillyman, NTBO, Inc.: http://www.ntbo.com" <waltl@ntbo.com> ******
Bless you, Mike. Long Live MiniVend and mySQL.
Walt;
P.S. (Shameless plug): My first MiniVend store is now accepting
orders at http://www.showmeblinds.com. Come, order some window blinds!
At 10:26 PM 2/9/99 -0500, you wrote:
>****** 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
