Re: [lookup] speed sales pitch

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53525
interpreted = N
texte = >I don't believe that is true. It was always my understanding that WebCatalog did perform some indexing, but not in a way that the developer had any control over. It is far too fast to be doing exclusively fulltext searches all the time. > They're full text searches without indexing. 1. lookup is faster since it has many restrictions (noted in other messages) 2. WebCat databases work well, even when they get big, but can get bogged down with doing date searches, and number searches to a lesser extent, since the data must be interpreted then compared. 3. WebCat begins to really have limitations, in my mind, when you have to do embedded searches to simulate SQL Joins - when these get slow that's when I tend to move to something else. However, there are many situations where doing embedded searches is fine, even with large databases, depending upon the type of data. Storage of customer data, for example, where you have a customer record, multiple address address records in a related database, and multiple invoice records in another database, works well even if all the databases get big since you're usually just finding a small number of records in each search. -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [lookup] speed sales pitch ( Kenneth Grome 2003)
  2. Re: [lookup] speed sales pitch ( John Hill 2003)
  3. Re: [lookup] speed sales pitch ( John Peacock 2003)
  4. Re: [lookup] speed sales pitch ( Brian Fries 2003)
  5. Re: [lookup] speed sales pitch ( "Dan Strong" 2003)
  6. Re: [lookup] speed sales pitch ( Kenneth Grome 2003)
  7. Re: [lookup] speed sales pitch ( "Dan Strong" 2003)
  8. Re: [lookup] speed sales pitch ( Kenneth Grome 2003)
  9. Re: [lookup] speed sales pitch ( "Dan Strong" 2003)
  10. Re: [lookup] speed sales pitch ( John Peacock 2003)
  11. Re: [lookup] speed sales pitch ( "Dan Strong" 2003)
  12. Re: [lookup] speed sales pitch ( "Dan Strong" 2003)
  13. Re: [lookup] speed sales pitch ( Donovan Brooke 2003)
  14. Re: [lookup] speed sales pitch ( John Peacock 2003)
  15. [lookup] speed sales pitch ( "Dan Strong" 2003)
>I don't believe that is true. It was always my understanding that WebCatalog did perform some indexing, but not in a way that the developer had any control over. It is far too fast to be doing exclusively fulltext searches all the time. > They're full text searches without indexing. 1. lookup is faster since it has many restrictions (noted in other messages) 2. WebCat databases work well, even when they get big, but can get bogged down with doing date searches, and number searches to a lesser extent, since the data must be interpreted then compared. 3. WebCat begins to really have limitations, in my mind, when you have to do embedded searches to simulate SQL Joins - when these get slow that's when I tend to move to something else. However, there are many situations where doing embedded searches is fine, even with large databases, depending upon the type of data. Storage of customer data, for example, where you have a customer record, multiple address address records in a related database, and multiple invoice records in another database, works well even if all the databases get big since you're usually just finding a small number of records in each search. -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com ------------------------------------------------------------- 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://webdna.smithmicro.com/ John Hill

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:

read and write you own cookies with webcat (1997) [WriteFile] problems (1997) apostrophe in search item (1997) Include file not working on remote directory. (2004) Fun with dates (1997) Test (2006) HELP WITH DATES (1997) [format] (1998) RE:DatabaseHelper (1997) Replace context problem ... (1997) E-Commerce site for Canadian and US customers (1998) Content-type:... (2000) Sort Order on a page search (1997) [Webcat 2]Next (1997) Carts & cookies (1999) Attention all list readers (1997) Running 2 two WebCatalog.acgi's (1996) Convert Chars Issue? (2000) 2nd WebCatalog2 Feature Request (1996) no global [username] or [password] displayed ... (1997)