Re: [WebDNA] Server load
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100461
interpreted = N
texte = --Apple-Mail-51--700429526Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bitA lot about your questions (if I understood correctly) has to do with general database theory, actually. And you will probably find there are as many theories as there are programmers! In general, though, I can tell you one thing that almost all programmers will agree on: If you can modularize your code, you should. So in any instance where you feel a piece of data you had to construct through a search, lookup or calculation will be reused, you should objectify that data. Setting up a variable or a cookie is a great way to do this. I've had good luck incorporating values from WebDNA into JavaScript even, though that definitely gets more complicated due to the differences in browsers. If you will use that data across several pages, putting that code in an include file is common practice as well. It shortens your code base.Our company has monitored processor usage carefully. We are running a LOT of WebDNA sites, some of them very heavily used, on a Dual G5 xServe (hurry up with that Intel version, Donovan!). Processor usage FOR EVERYTHING HAPPENING ON THAT SERVER seldom goes over 25%. I would not worry about your processor speed, unless it's a very old machine.RAM, is of course, very important. The more you have, the smoother things operate. The execution of your scripts and lookups will rely more on RAM and the speed of your hard drives than on processor. Upgrading your hard drives to 10,000 RPM models will speed up your file access noticeably.Hope this helps!-----Patrick Junkroski, ACTC, ACDTPresident/CEOhttp://www.vsm.net239.642.0304--Apple-Mail-51--700429526Content-Disposition: inline;filename=Consultnts_Ntwrk_Blk_1ln_sm.jpgContent-Type: image/jpeg;x-unix-mode=0644;name="Consultnts_Ntwrk_Blk_1ln_sm.jpg"Content-Transfer-Encoding: base64/9j/4AAQSkZJRgABAQEASABIAAD/4QB0RXhpZgAATU0AKgAAAAgABAEaAAUAAAABAAAAPgEbAAUAAAABAAAARgEoAAMAAAABAAIAAIdpAAQAAAABAAAATgAAAAAAAABIAAAAAQAAAEgAAAABAAKgAgAEAAAAAQAAAJagAwAEAAAAAQAAABkAAAAA/9sAQwACAgICAgECAgICAgICAwMGBAMDAwMHBQUEBggHCAgIBwgICQoNCwkJDAoICAsPCwwNDg4ODgkLEBEPDhENDg4O/9sAQwECAgIDAwMGBAQGDgkICQ4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4O/8AAEQgAGQCWAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5+v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5+jp6vLz9PX29/j5+v/aAAwDAQACEQMRAD8A/ZP4oftFfBD4L6rYaf8AFD4l+GfCGpXib7ayupy9w6Zxv8qMM4TORuIC8Hnivzv/AGg/jZoPjz9uj4Z32sftJ/D3wP8AsqaH9j1eWPRPEy3V94rvEk80wvbWm+YRKyxofOCoAHIDMRj8SfjZ428S/EX9rr4jeM/F/wBrj8Q6lr9y1zbXLEvZhJWRLbnoIlVYwO22vLcAEkAAnr70Af2meAfiN4E+KXw8t/Fnw78V6J4w8PTMUW90y5EqK46o46o4yMqwBGRxXa18WfsAfDzwN4H/AOCX3wz1LwdbWb3nijSotX1/Uo8GS8vZARIHb/pkQYgv8ITHXOfePjp8UB8HP2XvE3j+PSTr2o2fkW2l6Z53lC7vLmeO2to2fB2IZZU3Ng4XJwaAPW6K+av+Eo+Ivwd+Huq/EH4/fEXwp4h0UwQwRaF4U8HTQTJqE80ccNvau1zJJcl3cRKrIpZmDEqMiqd1+1n8PdL0vUU13w38RtC8T6f4j0/Qr3wtc6Ir6pFcagjtZMI4pHSSKby2VXjdhuBBwQcAH1DRXy4n7WfgCTw7YmPwx8RG8XXXi2fwsvg2TTIYtXTUYbb7XJEweZYAPIKyK3nYcMoXcxxXT67+0b4B8N+GPizqur2nie3j+HI0/wD4SSD7CplRr6GGaJYxvw7BZkDcjBDDnGaAPfKK+Brv9qnxh4L8c+M7HVvB2ufESB/jsfBOjxaNbwxPY2h0+1uVXkr505Z5dgYjd82XXaAfojV/j34Z8OftC+Gfh34k8O+MfD914hv00/RtXvLWAWN3dNA0ywrtmMwJCuocxCPepXfnGQD3Givk7w7+2B8P/FSaI+i+EPig0Ov6bqF14XubrQlhg1yawjeS5s7dzLzOojfG4KjbG2u2DWZ4H/a+0jxL8APhL4n1b4b+PbLxZ8QEmbQ/DOnwwTzXaQQpPNPBJJLGjwKsigFikjnO2PigD7Eor5l/ah+KXxG+F3wc8Dat8LtF0rX/ABVrHjSy0saTqSNi8heG4mkgQqw2TOIAiMcgMwyDXE6T+1v4ZvfiB4h8SS30c3wmT4eaFr2kfZrJn1Ke+1G/vLP7HsDczGSGKERYBWTfuOM4APtCivjPxd+2LpGi6VoA0H4a+PNc8QTePrPwprugSRW8d7pMlxEJ42IWVo5WliYNEEkKP8wLoVIr0O+/af8AhlpN4tprH/CQ6RqH/CwoPA0lndWIEsOoTQxzo7gOQLcxyxt5ucDcOKAPomivmi5/am8Cvrr6N4c8M/ETxx4hF9qsCaT4f0hJriSDTLgWt3ejfKifZhPmJGLBpHBCK2Kzn/au+H/iG50vRPAFv4u8Taxrng0eJdNvbHRi9pZ2bm5iE90zkeSI5rdo3VxuDMoAb5sAH1RRXy/+zP8AHdfi98DPBkV2dQ8QeMYfBel6l4t1mzski02G/urdJWtN4IX7RtYSNEgIjVl3FSyglAH4Zf8ABR39m7W/hD+2prvxF0zTZ5Phv45vn1G1vYoyYrK/k+a5tpCBhSz7pUz95XIGShr4J1Hwt4o0jw7Z6xq3hnxFpWkXf/HpfXumTQ28/wDuSMoVvwJr+x74qf8AJGb7/r4g/wDRq1F8Sf8Akiv/AG2t/wD0IUAfA/8AwSz+F/xQ8Dfsa6x4i8d6lrtj4c8S3iXPhXwvfEhLOABt92EYZjM7MCF4BVA+PnzX6CfFH4ceHvi58BfEfw88U/bF0bWLcRyTWcvlXFtIjrJFPE+DtkjkRHU4IyoyCOK7xP8AVL9BTqAPlDWfgB8S/GvwmufCPxF+Op8TQ2c1lfeG9Vs/B0Flf6fqNncxXFteTMJmjuCGiCtGI41cM3Q4xR/4ZZvdY+IZ8d+NfiRJr/j+48aaDr99f2ehLaWht9GMptrCG381zGjGeVmkaR2LOTjAAH17RQB8f+OP2VpvFegfFrS7fxf4cFh8QPFTa3qUOu+Dk1MWJOn29kn2Ym4jMc8fkeak/UM2NvGTzvi79jjVNe0vx3oWj/GfW9I8K+NNE0ey8TW9/ocWoXt3caXBFBDci5aRSvmJDH5q7SWIJVkya+4qKAPkrxF+y9cajZ+JrvQfiFLofiS9+LcHxF0q+n0RbmGxuorWK2FtJD5q+dEURiTuQ5cf3ecOX9kNrj9qWP4jXPj+zuUT4hw+NBHN4VhfUmmSHyTYm/MvmfYlGTHEqjy88l8V9o0UAfK/hX9mCw8M+CvgDoh8Y3l/D8MbzVLiOQ6esZ1QX1vdQMrfOfK2C6JBG7OwdM8cPe/si6/qH7D/AIa+A9/8S/DWp+G9ESW00/U77wIkuoWdrhFtpLaX7SPIvoAHxcqOS4JjG3n7gooA8n8c/CyHxrpfwttZdfvrT/hC/Fdhr0c0sQnlv2tYpYxHIxIwX83Jfk5HTmvnjxB+w74I1nxn8Z9QtfEt9pel+O5dOvbXSP7NinttEv7O8e9M0aSEpLDLcSO8lu67T5kgz8/H2/RQB8gXf7Ll5P8AA7TdE0/xL8PvB/jHSvGlh4p0vWfCvw6g0yzE9mCIkuLNJz54IaTLGVT84xjbzd8bfsoaD45+OPj7xxqXiq/guPE/hD+yTZQ2S+VY6nsjjGsR5bPniOCBAh4Aj+9zX1lRQB8jWX7MGq+EI/h9q3ww+J0vhLxv4e8Iz+GtS1jUNATUYdZgnnF3NPJbmVPLn+1eZOrByAZGVlcGtL4cfss+H/hjqsj6D4n1S4sm+G0Xg7yru2VpXYXV3dy3zyAgNJJJdyEoFCjHB7D6nooA+VPgd+zGn7Pos7XwB4z8nQpfDNnp+u6NcaR/ouo6lbKsf9roqygwTyxjbKoJDkIxOVySvquigD//2Q==--Apple-Mail-51--700429526Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bitOn Aug 7, 2008, at 11:47 AM, Frank Nordberg wrote:> Brian B. Burton wrote:>> these are GREAT questions!>> Thanks! I wasn't sure but I kind'a hoped they were of interest to > others than me as well.>> An important part of the problem is that WebDNA is actually too > good! It's sooo tempting and easy to add just one more little script > and another little script and...>>> Frank Nordberg> http://www.musicaviva.com> http://stores.ebay.com/Nordbergs-Music-Store?refid=store> http://www.abc-notation.com> http://www.online-guitarist.com> http://www.gitar-siden.com> http://www.tablatvre.com> http://www.mandolin-player.com> http://www.blues-harmonica.com> http://www.irish-banjo.com> http://www.blues-banjo.com> http://www.folk-banjo.com> http://www.roarogfrank.com>> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: --Apple-Mail-51--700429526--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-51--700429526Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bitA lot about your questions (if I understood correctly) has to do with general database theory, actually. And you will probably find there are as many theories as there are programmers! In general, though, I can tell you one thing that almost all programmers will agree on: If you can modularize your code, you should. So in any instance where you feel a piece of data you had to construct through a search, lookup or calculation will be reused, you should objectify that data. Setting up a variable or a cookie is a great way to do this. I've had good luck incorporating values from WebDNA into JavaScript even, though that definitely gets more complicated due to the differences in browsers. If you will use that data across several pages, putting that code in an include file is common practice as well. It shortens your code base.Our company has monitored processor usage carefully. We are running a LOT of WebDNA sites, some of them very heavily used, on a Dual G5 xServe (hurry up with that Intel version, Donovan!). Processor usage FOR EVERYTHING HAPPENING ON THAT SERVER seldom goes over 25%. I would not worry about your processor speed, unless it's a very old machine.RAM, is of course, very important. The more you have, the smoother things operate. The execution of your scripts and lookups will rely more on RAM and the speed of your hard drives than on processor. Upgrading your hard drives to 10,000 RPM models will speed up your file access noticeably.Hope this helps!-----Patrick Junkroski, ACTC, ACDTPresident/CEOhttp://www.vsm.net239.642.0304--Apple-Mail-51--700429526Content-Disposition: inline;filename=Consultnts_Ntwrk_Blk_1ln_sm.jpgContent-Type: image/jpeg;x-unix-mode=0644;name="Consultnts_Ntwrk_Blk_1ln_sm.jpg"Content-Transfer-Encoding: base64/9j/4AAQSkZJRgABAQEASABIAAD/4QB0RXhpZgAATU0AKgAAAAgABAEaAAUAAAABAAAAPgEbAAUAAAABAAAARgEoAAMAAAABAAIAAIdpAAQAAAABAAAATgAAAAAAAABIAAAAAQAAAEgAAAABAAKgAgAEAAAAAQAAAJagAwAEAAAAAQAAABkAAAAA/9sAQwACAgICAgECAgICAgICAwMGBAMDAwMHBQUEBggHCAgIBwgICQoNCwkJDAoICAsPCwwNDg4ODgkLEBEPDhENDg4O/9sAQwECAgIDAwMGBAQGDgkICQ4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4ODg4O/8AAEQgAGQCWAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5+v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5+jp6vLz9PX29/j5+v/aAAwDAQACEQMRAD8A/ZP4oftFfBD4L6rYaf8AFD4l+GfCGpXib7ayupy9w6Zxv8qMM4TORuIC8Hnivzv/AGg/jZoPjz9uj4Z32sftJ/D3wP8AsqaH9j1eWPRPEy3V94rvEk80wvbWm+YRKyxofOCoAHIDMRj8SfjZ428S/EX9rr4jeM/F/wBrj8Q6lr9y1zbXLEvZhJWRLbnoIlVYwO22vLcAEkAAnr70Af2meAfiN4E+KXw8t/Fnw78V6J4w8PTMUW90y5EqK46o46o4yMqwBGRxXa18WfsAfDzwN4H/AOCX3wz1LwdbWb3nijSotX1/Uo8GS8vZARIHb/pkQYgv8ITHXOfePjp8UB8HP2XvE3j+PSTr2o2fkW2l6Z53lC7vLmeO2to2fB2IZZU3Ng4XJwaAPW6K+av+Eo+Ivwd+Huq/EH4/fEXwp4h0UwQwRaF4U8HTQTJqE80ccNvau1zJJcl3cRKrIpZmDEqMiqd1+1n8PdL0vUU13w38RtC8T6f4j0/Qr3wtc6Ir6pFcagjtZMI4pHSSKby2VXjdhuBBwQcAH1DRXy4n7WfgCTw7YmPwx8RG8XXXi2fwsvg2TTIYtXTUYbb7XJEweZYAPIKyK3nYcMoXcxxXT67+0b4B8N+GPizqur2nie3j+HI0/wD4SSD7CplRr6GGaJYxvw7BZkDcjBDDnGaAPfKK+Brv9qnxh4L8c+M7HVvB2ufESB/jsfBOjxaNbwxPY2h0+1uVXkr505Z5dgYjd82XXaAfojV/j34Z8OftC+Gfh34k8O+MfD914hv00/RtXvLWAWN3dNA0ywrtmMwJCuocxCPepXfnGQD3Givk7w7+2B8P/FSaI+i+EPig0Ov6bqF14XubrQlhg1yawjeS5s7dzLzOojfG4KjbG2u2DWZ4H/a+0jxL8APhL4n1b4b+PbLxZ8QEmbQ/DOnwwTzXaQQpPNPBJJLGjwKsigFikjnO2PigD7Eor5l/ah+KXxG+F3wc8Dat8LtF0rX/ABVrHjSy0saTqSNi8heG4mkgQqw2TOIAiMcgMwyDXE6T+1v4ZvfiB4h8SS30c3wmT4eaFr2kfZrJn1Ke+1G/vLP7HsDczGSGKERYBWTfuOM4APtCivjPxd+2LpGi6VoA0H4a+PNc8QTePrPwprugSRW8d7pMlxEJ42IWVo5WliYNEEkKP8wLoVIr0O+/af8AhlpN4tprH/CQ6RqH/CwoPA0lndWIEsOoTQxzo7gOQLcxyxt5ucDcOKAPomivmi5/am8Cvrr6N4c8M/ETxx4hF9qsCaT4f0hJriSDTLgWt3ejfKifZhPmJGLBpHBCK2Kzn/au+H/iG50vRPAFv4u8Taxrng0eJdNvbHRi9pZ2bm5iE90zkeSI5rdo3VxuDMoAb5sAH1RRXy/+zP8AHdfi98DPBkV2dQ8QeMYfBel6l4t1mzski02G/urdJWtN4IX7RtYSNEgIjVl3FSyglAH4Zf8ABR39m7W/hD+2prvxF0zTZ5Phv45vn1G1vYoyYrK/k+a5tpCBhSz7pUz95XIGShr4J1Hwt4o0jw7Z6xq3hnxFpWkXf/HpfXumTQ28/wDuSMoVvwJr+x74qf8AJGb7/r4g/wDRq1F8Sf8Akiv/AG2t/wD0IUAfA/8AwSz+F/xQ8Dfsa6x4i8d6lrtj4c8S3iXPhXwvfEhLOABt92EYZjM7MCF4BVA+PnzX6CfFH4ceHvi58BfEfw88U/bF0bWLcRyTWcvlXFtIjrJFPE+DtkjkRHU4IyoyCOK7xP8AVL9BTqAPlDWfgB8S/GvwmufCPxF+Op8TQ2c1lfeG9Vs/B0Flf6fqNncxXFteTMJmjuCGiCtGI41cM3Q4xR/4ZZvdY+IZ8d+NfiRJr/j+48aaDr99f2ehLaWht9GMptrCG381zGjGeVmkaR2LOTjAAH17RQB8f+OP2VpvFegfFrS7fxf4cFh8QPFTa3qUOu+Dk1MWJOn29kn2Ym4jMc8fkeak/UM2NvGTzvi79jjVNe0vx3oWj/GfW9I8K+NNE0ey8TW9/ocWoXt3caXBFBDci5aRSvmJDH5q7SWIJVkya+4qKAPkrxF+y9cajZ+JrvQfiFLofiS9+LcHxF0q+n0RbmGxuorWK2FtJD5q+dEURiTuQ5cf3ecOX9kNrj9qWP4jXPj+zuUT4hw+NBHN4VhfUmmSHyTYm/MvmfYlGTHEqjy88l8V9o0UAfK/hX9mCw8M+CvgDoh8Y3l/D8MbzVLiOQ6esZ1QX1vdQMrfOfK2C6JBG7OwdM8cPe/si6/qH7D/AIa+A9/8S/DWp+G9ESW00/U77wIkuoWdrhFtpLaX7SPIvoAHxcqOS4JjG3n7gooA8n8c/CyHxrpfwttZdfvrT/hC/Fdhr0c0sQnlv2tYpYxHIxIwX83Jfk5HTmvnjxB+w74I1nxn8Z9QtfEt9pel+O5dOvbXSP7NinttEv7O8e9M0aSEpLDLcSO8lu67T5kgz8/H2/RQB8gXf7Ll5P8AA7TdE0/xL8PvB/jHSvGlh4p0vWfCvw6g0yzE9mCIkuLNJz54IaTLGVT84xjbzd8bfsoaD45+OPj7xxqXiq/guPE/hD+yTZQ2S+VY6nsjjGsR5bPniOCBAh4Aj+9zX1lRQB8jWX7MGq+EI/h9q3ww+J0vhLxv4e8Iz+GtS1jUNATUYdZgnnF3NPJbmVPLn+1eZOrByAZGVlcGtL4cfss+H/hjqsj6D4n1S4sm+G0Xg7yru2VpXYXV3dy3zyAgNJJJdyEoFCjHB7D6nooA+VPgd+zGn7Pos7XwB4z8nQpfDNnp+u6NcaR/ouo6lbKsf9roqygwTyxjbKoJDkIxOVySvquigD//2Q==--Apple-Mail-51--700429526Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bitOn Aug 7, 2008, at 11:47 AM, Frank Nordberg wrote:> Brian B. Burton wrote:>> these are GREAT questions!>> Thanks! I wasn't sure but I kind'a hoped they were of interest to > others than me as well.>> An important part of the problem is that WebDNA is actually too > good! It's sooo tempting and easy to add just one more little script > and another little script and...>>> Frank Nordberg> http://www.musicaviva.com> http://stores.ebay.com/Nordbergs-Music-Store?refid=store> http://www.abc-notation.com> http://www.online-guitarist.com> http://www.gitar-siden.com> http://www.tablatvre.com> http://www.mandolin-player.com> http://www.blues-harmonica.com> http://www.irish-banjo.com> http://www.blues-banjo.com> http://www.folk-banjo.com> http://www.roarogfrank.com>> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: --Apple-Mail-51--700429526--
Patrick Junkroski
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:
Webten + Webcat running smooth (1998)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
Webcatalog quitting (1997)
[Price] (1997)
setting username and password using a form. (2000)
Need relative path explanation (1997)
Date problems-more (1997)
Can Web Cat Do this? - LOOK (2000)
database size? (1997)
Echo (2004)
fresh eyes needed. Append won't work. (2000)
WebCat cannot handle compatible search parameters? (1997)
ShowNext Command (1997)
Date/Time format problems (1997)
[ShowNext] (1997)
WebCatalog can't find database (1997)
math a various prices (1997)
ShowIf variables (1997)
AuthenticateChecker (2000)
CVS Files for databases (2000)