Re: Category Form Selection or Database Type

[Birgitt Funk <birgitt@minivend.com>]

******    message to minivend-users from Birgitt Funk <birgitt@minivend.com>     ******


Brett wrote:
> one put a pop-up menu of all the categories available for an
> automatic form search? I can do this manually, but if the categories change
> it would be nice if the pop-up of all of them could change with the
> database.
> 
> 2. Also, if I have 10,000+ products, is the default ".GDBM" or ".DB"
> efficient enough for this? Or is SQL a better means?
> 

This has been answered several times during the last few days and
weeks. Please read the archives. .gdbm is efficient even for 500 000 +
records product.asc files. When searching for single keywords as in a
text string like a title, use glimpse searches on the indexed products
files (see docs for a very nice description how to do it) and if you
have a large product.asc file use the split(1) UNIX/POSIX command
(also very nicely described in the docs) to make small index files.

If you can search for matching strings at the beginning of a field use
binary searches on a dictionary-ordered pre-built index. (Again also
this is described in the docs). If you have to use SQL please read the
archives about what you have to do considering indexing. It just has
been discussed in length.

As for category searches, Mike Heins has given very helpful hints in
his answer to Thomas Walker on Thursday.

It is really worth while to follow the list and to read and search the
docs and the archives these days. 

Have fun. :-)

Birgitt Funk


> Any input is welcome.
> Thanks,
> brett
> 
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> Brett Coleman                       NeuConcept Productions Inc.
>  brett@neuconcept.com                http://www.neuconcept.com
>   http://www.neuconcept.com/pager     314-605-8000
> -
> 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