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 Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 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 Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 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:
RE: Re:Signal Raised (1997)
Viewing old carts (was FEW QUESTIONS) (1997)
Sort Order on a page search (1997)
ShowNext Command (1997)
ShowNext (1997)
webcat serving up 2+ versions of the same db!!!?? (2000)
watch out for format_to_days on NT (1997)
Can you do this??? and other stuff (1997)
Re:Help name our technology! (1997)
General WebCatalog Questions (1997)
HELP WITH DATES (1997)
Templates in Memory (2000)
Up and running ... at last !! (1997)
Unexpected comparison behavior change in 4.5.1 (2003)
ANN: Strategic Partnership with BuyStream Announced. (2000)
[WebDNA] HTTP post help (2012)
Re:Comments Convertion-part2 (1998)
Sku numbers (1997)
Help!!!! (1999)
Showif = stumped? (2001)