Re: MySQL and Decimals
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57851
interpreted = N
texte = Larry Hewitt wrote:> [SQLExecute conn_ref=conn1&result_var=1]> SELECT * FROM QUICKFACTS ORDER by ID;> [/SQLExecute]FWIW, this is sloppy code; you should always specify the fieldnames in your SQL query, even if you intend to use all of them. The reason for that is performance; if you use "SELECT *" then the query optimizer has to lookup the fields in the system table, then check for any applicable indexes, and only then perform the actual query.Since WebDNA does not support cursors, every single page will require all of the above steps. If you can cut out the system table query, you can save precious CPU cycles for more important use.John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 301-429-5748-------------------------------------------------------------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:
Larry Hewitt wrote:> [SQLExecute conn_ref=conn1&result_var=1]> SELECT * FROM QUICKFACTS ORDER by ID;> [/SQLExecute]FWIW, this is sloppy code; you should always specify the fieldnames in your SQL query, even if you intend to use all of them. The reason for that is performance; if you use "SELECT *" then the query optimizer has to lookup the fields in the system table, then check for any applicable indexes, and only then perform the actual query.Since WebDNA does not support cursors, every single page will require all of the above steps. If you can cut out the system table query, you can save precious CPU cycles for more important use.John-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 301-429-5748-------------------------------------------------------------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 Peacock
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:
SEARCH RESULTS (1998)
[Price] (1997)
upgrading (1997)
Documentation Feedback (1997)
Extended [ConvertChars] (1997)
Practice runs ? (1997)
Price and Formula.db (2002)
[WebDNA] Best WebDNA version for OS X Server 10.5.8 on PowerPC? (2010)
Capturing the referring site (1999)
Canadian Postal Codes (2001)
Logging purchases (1997)
Checking Out! (1999)
access denied problem (1997)
Wireless WebDNA available today! (2000)
[WebDNA] Search Problem (2011)
[urgent] Phone number at SM (2006)
Math Problem - Format? (1997)
WebCat cannot handle compatible search parameters? (1997)
Re:WebCatalog vidoes (was: Prices Dropped) (1998)
MasterCounter and capitalization (1997)