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:

StoreBuilder v4.0.2 Question (2001) quantity minimum problem (1997) Keep away (1997) Almost a there but..bye bye NetCloak (1997) Bug report 06/30/2000 -- the no space in field name bug ... (2000) Date math (1997) read and write you own cookies with webcat (1997) WebCatalog/Mac 2.1b2 - PIXO (1997) X Server (1999) Tab Charactor (1997) RE: NewCart+Search with one click ? (1997) Change to 5.0 per website licensing (2003) Compressed cookies - follow-up (2003) Request for page test (2003) Forms Search Questions (1997) emailer (1997) Re:Running 2 two WebCatalog.acgi's (1996) Help formatting search results w/ table (1997) form data submission get (1997) Carts & Refering URLs (1997)