Re: SQL performance

[mikeh@minivend.com]

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

Quoting mikeh@minivend.com (mikeh@minivend.com):
> ******    message to minivend-users from mikeh@minivend.com     ******
> 
> Quoting mikeh@minivend.com (mikeh@minivend.com):
> > 
> > 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.
> 

Here is a nice synonym for [sql-list]:

[new]
[search-region arg="
    st=sql 
    ml=1000
    sq=select code,title,artist,price from products where code < '5'
    "]
<PRE>
[search-list][item-code]: [item-param title] [item-param artist] [item-param price]
[/search-list]
</PRE>

[/search-region]

That gives me an INSTANTANEOUS return on a 15,550 record database.

This gives fast named-field access -- case closed. I didn't think my
SQL stuff was THAT bad.

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
Few blame themselves until they     131 Willow Lane, Floor 2  | ||  _ \
have exhausted all other            Oxford, OH  45056         | || |_) |
possibilities.                      <mikeh@minivend.com>     |___|  _ <
 -- anonymous                       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