Re: MySQL and Decimals

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57853
interpreted = N
texte = Hi, I started experimenting with MySQL as well. I started a MySQl Admin that I hope will be similar to if not better than phpmyadmin. I haven't had much time to work on it lately, but you can check it out here. http://69.44.60.22/MySqlDNA/default.tpl Username: webdna Password: mysql Salvatore B. D'Anna DotNetNuke Hosting V:(619)306-7606 F: (619)374-2268 http://DotNetNukeHosting.com -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Larry Hewitt Sent: Friday, May 14, 2004 12:28 PM To: WebDNA Talk Subject: Re: MySQL and Decimals John - Thanks for the info. I am just now experimenting with MySQL, and appreciate the tips. Larry On May 14, 2004, at 12:03 PM, John Peacock wrote: > 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/ > > Larry Hewitt360.807.1100 OFFICE HCO, LLC360.807.1103 FAX 1133 Kresky NE #106360.508.6231 CELL Centralia, WA 98531larryh@hewittco.com www.hewittco.com www.votewashington.org ------------------------------------------------------------- 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/ __________ NOD32 1.759 (20040513) Information __________ This message was checked by NOD32 Antivirus System. http://www.nod32.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: MySQL and Decimals ( "Sal" 2004)
  2. Re: MySQL and Decimals ( Larry Hewitt 2004)
  3. Re: MySQL and Decimals ( John Peacock 2004)
  4. Re: MySQL and Decimals ( Larry Hewitt 2004)
  5. Re: MySQL and Decimals ( Larry Hewitt 2004)
  6. Re: MySQL and Decimals ( Larry Hewitt 2004)
  7. Re: MySQL and Decimals ( John Peacock 2004)
  8. MySQL and Decimals ( Larry Hewitt 2004)
Hi, I started experimenting with MySQL as well. I started a MySQl Admin that I hope will be similar to if not better than phpmyadmin. I haven't had much time to work on it lately, but you can check it out here. http://69.44.60.22/MySqlDNA/default.tpl Username: webdna Password: mysql Salvatore B. D'Anna DotNetNuke Hosting V:(619)306-7606 F: (619)374-2268 http://DotNetNukeHosting.com -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Larry Hewitt Sent: Friday, May 14, 2004 12:28 PM To: WebDNA Talk Subject: Re: MySQL and Decimals John - Thanks for the info. I am just now experimenting with MySQL, and appreciate the tips. Larry On May 14, 2004, at 12:03 PM, John Peacock wrote: > 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/ > > Larry Hewitt360.807.1100 OFFICE HCO, LLC360.807.1103 FAX 1133 Kresky NE #106360.508.6231 CELL Centralia, WA 98531larryh@hewittco.com www.hewittco.com www.votewashington.org ------------------------------------------------------------- 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/ __________ NOD32 1.759 (20040513) Information __________ This message was checked by NOD32 Antivirus System. http://www.nod32.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/ "Sal"

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:

[WebDNA] Topic... (2004) Tax Troubles (2003) multi-paragraph fields (1997) Help formatting search results w/ table (1997) Cookie set browser session. (1998) WebCat2 several catalogs? (1997) Emailer help....! (1997) WCS Newbie question (1997) Convert "&" to "&" using [grep] (2006) autosensing lanague selection (1997) FTP Address (2003) Design Help Needed (1998) Simple Database close connection (2001) no global [username] or [password] displayed ... (1997) NewCart+Search with one click ? (1997) Bulk Email >>>>Any ideas? (2001) WebMerchant 1.6 and SHTML (1997) Random sort is not random at all..... (2000) [GROUPS] followup (1997) Cart doesn't interpret tag! (1997)