Re: Full text search
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22403
interpreted = N
texte = >I am just wondering, what has more effect on speed with wo???data:>Number of records? Number of fields? Can I multiply records x fields to get>a rule of thumb for a specific machine?>My search requires grouping - does grouping speed up or slow down?Yes, you can probably do simple multiplication as a rule of thumb.Grouping slows down linearly with the number of fields you add to thegroup, as though you had added more wo????data fields.>I tried to push WebCat beyond the limit, with 500.000 records and 10>fields. Like all databases it is still usable, when it finds one or few>records. But it gets exhausted (no wonder) when it finds many records.>Maybe I should set up a learning dirty words-system to store all requests>which return more then 500 records or so and forbid them in the future.>This technique makes sense with 4D - but makes it sense for WebCat too?Not sure exactly what this means, but if you're trying to 'clean up' searchrequests by removing words like a an and the for is before performing thesearch, then that's probably a good idea.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I am just wondering, what has more effect on speed with wo???data:>Number of records? Number of fields? Can I multiply records x fields to get>a rule of thumb for a specific machine?>My search requires grouping - does grouping speed up or slow down?Yes, you can probably do simple multiplication as a rule of thumb.Grouping slows down linearly with the number of fields you add to thegroup, as though you had added more wo????data fields.>I tried to push WebCat beyond the limit, with 500.000 records and 10>fields. Like all databases it is still usable, when it finds one or few>records. But it gets exhausted (no wonder) when it finds many records.>Maybe I should set up a learning dirty words-system to store all requests>which return more then 500 records or so and forbid them in the future.>This technique makes sense with 4D - but makes it sense for WebCat too?Not sure exactly what this means, but if you're trying to 'clean up' searchrequests by removing words like a an and the for is before performing thesearch, then that's probably a good idea.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
setting cookies for another domain? (2002)
WebDNA 6.0 OSX Commerce Edition for selling (2006)
shipcost (1997)
Problems appending to database (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
RE: PDF (1999)
[Q] Novice's question (1997)
For those of you not on the WebCatalog Beta... (1997)
re: date search problem (1999)
Pacific Coast Software responsiveness (was WebMerchant -MacAuthorize) (1999)
Electronic Delivery (1997)
OT: Verisign buys Thawte (1999)
Help name our technology! I found it (1997)
Color (1997)
Roundup function? (1997)
calendar (2001)
all records returned. (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Tracking inbound links for discounts (1997)
Emailer (1998)