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:

Summary search -- speed (1997) [WebDNA] Send results to more pages? (2011) Is [thisurl] http or https? (1998) Mem per threads (1998) Weird cart problem (webcat 2.x) (2000) [WebDNA] anybody notice issues with convertchars FF3.5 mac (2009) RE: creating writefile data from a nested search (1997) [WebDNA] sum in a search (2009) Re2: AAgghh!! Help, please. SSL strikes again. (1997) FAX orders (1996) 2.0Beta Command Ref (can't find this instruction) (1997) Slow Code, how to speed up (2002) [WebDNA] Where is Speed Test? (2009) Displaying xx number of characters (1997) Finding max value for a field (1997) [format 40s]text[/format] doesn't work (1997) Text data with spaces in them... (1997) wo search help (1999) ERROR in docs (2003) Forms Search Questions (1997)