SQL speed issues

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38759
interpreted = N
texte = Hi, we're having some speed issues when using [SQL...][/SQL] tags. For some reason the query takes too long to return the results, even when there is only one record on the database!!! This is my query:[SQL dsn=sql7&username=theuser&password=thepassword&statement=SELECT * FROM vw_ItemFamily WHERE str_ItemNumber LIKE '%[keyword]%' OR str_Title LIKE '%[keyword]%' ORDER BY int_Order]If I run the query with ASP it runs super fast, but when I use [SQL] tag it takes over 10 seconds. Any ideas/suggestions?------------------------------------------------------------- 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:

    
  1. Re: SQL speed issues (John Peacock 2001)
  2. SQL speed issues (Pedro Rivera 2001)
Hi, we're having some speed issues when using [SQL...][/SQL] tags. For some reason the query takes too long to return the results, even when there is only one record on the database!!! This is my query:[SQL dsn=sql7&username=theuser&password=thepassword&statement=SELECT * FROM vw_ItemFamily WHERE str_ItemNumber LIKE '%[keyword]%' OR str_Title LIKE '%[keyword]%' ORDER BY int_Order]If I run the query with ASP it runs super fast, but when I use [SQL] tag it takes over 10 seconds. Any ideas/suggestions?------------------------------------------------------------- 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/ Pedro Rivera

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:

Dealing with return characters (2004) webcat crashes when using groups (1999) Size limit for tmpl editor ? (1997) Possible Bug in 2.0b15.acgi (1997) WebCatalog Features (1997) Error Msg (1997) virtual virtual hosted store.... (1998) WebCatalog for guestbook ? (1997) WebCatalog vs. Cold Fusion (1998) Re:PCS Customer submissions ? (1997) [WebDNA] encoding with webdna/JS, in context of various file encodings/charsets (2010) Processing all html files through WebCat or Typhoon (1998) SSL and reg web* (1997) no global [username] or [password] displayed ... (1997) Now when I send TeaRoom Order fields it does not post in Invoice. (1997) [BoldWords] WebCat.acgib15Mac (1997) contextual shownext (1998) WebCatalog vs WebDNA (2002) search engine friendly URLS (Mac) and Lycos! (1998) creator code (1997)