[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: building categories using sql
****** message to minivend-users from "Rob Zimmerman" ******
In an attempt to speed up my searchs I was looking at the dictionary indexing of the database mentioned in the docs.
Database products products.asc TAB
Database products INDEX title
Will build a second database product.asc.4 ( if title is the 4th column)
This is suppose to speed up dictionary type searches.
Dont know if this is of any use to you but thought I would thow it in the ring....
search the all-in-one doc for dictionary indexing.
Rob
----------
> This is actually the desired effect, but I would like to accomplish this
> without using scan. The page build time is too long, so I would rather
> build the page directly from a second sql query. Let's say that I build a
> list using the above query. If someone clicks on a varietal such as
> 'merlot', I would like the next page to contain a query like so:
>
> [sql type=list
> query="select code,title,year,varietal,vineyard, from products where
> varietal like
> '[value varietal]' order by title
- 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
