Re: SOLUTION? Re: Me know logical no need

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41368
interpreted = N
texte = On 7/10/02 9:39 AM, John Peacock wrote:> I would recommend ignoring all Solutions relying completely on WebCat. This > is a good job for a preparsing script in Perl (or some other language). I > would > go further to say that the majority of this data does not belong in WebCatalog > at all; store the bulk of the information in a SQL database of some sort and > extract only the fields that need to be searchable and put only that data in > WebCatalog itself. Once a record set has been identified, extract the > associated information using the [SQL] context. RAM is cheap but you are > starting to be CPU bound if you have to full text search a 500MB database.We already are planning on running a Perl preprocess to clean up the data and now we're just trying to plan out other uses. Putting in SQL and pulling out only the relevant data is an interesting idea that we might play with.Thanks> p.s. any WebCat database with 150 fields is, IMNSHO, bad design. Just because > you can, doesn't mean you should...Don't bother explaining that to us. ;) We've been trying to explain that to the MLS for the last 2 years.-- Jesse Williams-Proudman || CEO NineWire Digital Solutions || +1.888.873.6199 jesse@ninewire.com || http://ninewire.com Mac Web Hosting & Colocation || Mac Nationwide Dialup $75 Xserve Colocation Special from Your Mac ISP! ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
On 7/10/02 9:39 AM, John Peacock wrote:> I would recommend ignoring all Solutions relying completely on WebCat. This > is a good job for a preparsing script in Perl (or some other language). I > would > go further to say that the majority of this data does not belong in WebCatalog > at all; store the bulk of the information in a SQL database of some sort and > extract only the fields that need to be searchable and put only that data in > WebCatalog itself. Once a record set has been identified, extract the > associated information using the [SQL] context. RAM is cheap but you are > starting to be CPU bound if you have to full text search a 500MB database.We already are planning on running a Perl preprocess to clean up the data and now we're just trying to plan out other uses. Putting in SQL and pulling out only the relevant data is an interesting idea that we might play with.Thanks> p.s. any WebCat database with 150 fields is, IMNSHO, bad design. Just because > you can, doesn't mean you should...Don't bother explaining that to us. ;) We've been trying to explain that to the MLS for the last 2 years.-- Jesse Williams-Proudman || CEO NineWire Digital Solutions || +1.888.873.6199 jesse@ninewire.com || http://ninewire.com Mac Web Hosting & Colocation || Mac Nationwide Dialup $75 Xserve Colocation Special from Your Mac ISP! ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Jesse Williams-Proudman

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:

Various Problems (1997) Header info in content (1998) Next (1997) Error Log.db --however (1997) I'm Baaaaaaaaaack - Questions! (2000) Banner system (2000) [isfile] ? (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) Running _every_ page through WebCat ? (1997) Review comparison by PC Magazine: Open for On-line Business (1997) WebCat b15 Mac plug-in (1997) # fields limited? (1997) Emailer prefs in two places ... (1997) [OT] Unix question (2002) SKU Question (1999) A Global Variable (1997) WebDNA tags in WebMerchant email templates ... (1997) Pre-flight public flag (1997) E-mailer error codes (1997) Re:2nd WebCatalog2 Feature Request (1996)