Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110759
interpreted = N
texte = --Apple-Mail=_0EE23578-8F87-48DD-9AD0-9BCE7636AD7DContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=windows-1252Hi Palle! you do not specify what version of WebDNA you are using. You =might remember that the server version (6.2), even when the =configuration preferences shows "Commit Databases: Only commit databases =to disk when instructed", WebDNA will anyway writes your base to disk: =264MB takes time to write.In this case, there is the solution to split your database: let's say by =categories. If you have about 20 categories, you could split your =database in 20 parts. If you want to enter a new item in a specific =category, then a short code will point WebDNA at the proper database, =that will take about 20 times faster to update. I used this method to =build a 14 million record database and got fast results: using the first =letter of each customer name and 26 databases=85 this method is used by =Google in their search algorithm: your request first hits a server that ="knows" which other server to search for an answer.=20Another point is WebDNA FastCGI: WebDNA FastCGI writes to RAM if you =check "Only commit databases to disk when instructed", which is much =faster.- chrisOn Oct 2, 2013, at 10:41 AM, Palle Bo Nielsen
=wrote:> Hi all,>=20> Looking for advise to optimise a webpage using WebDNA and large DB's.>=20> I have built a forum entirely in WebDNA and the DB's are getting big. =The main DB has the following characteristics=85>=20> - Columns: 11> - Rows: 847.121> - Size: 264 MB>=20> If I display the different generic topics within the Forum and the =most recent Post within each category etc. then the code is executing =quite fast (acceptable performance).>=20> But if I want to add the value of posts within each category or within =each thread then the performance is slowing the too much.>=20> I have a category DB which eventually show 25 topics on the main page =of the forum, then I do a search into the main DB and search for all =posts with this categories ID and show the numFound. This is repeated =for every unique Topic.>=20>=20>=20> << Searching for the Topics >>> [search =db=3D/forum/db/db1.db&eqdb1_publishdata=3D1&asdb1_prioritysort=3D1&db1_pri=oritytype=3Dnum&AllReqd=3DT][founditems]>=20> << Searching for the numFound Value - This One is Pulling a Lot of =Performance even though it's simple, but there is a lot of data to =search through >>> [search =db=3D/forum/db/db4.db&eqdb4_publishdata=3D1&eqdb4_db1data=3D[db1_sku]&AllR=eqd=3DT][numFound][founditems][/founditems][/search]>=20>=20>=20> I would appreciate any good advise or ideas on how to accelerate the =performance. Some kind of indexing to avoid live searching would be =great, but how?>=20> /Palle>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us--Apple-Mail=_0EE23578-8F87-48DD-9AD0-9BCE7636AD7DContent-Disposition: attachment;filename=smime.p7sContent-Type: application/pkcs7-signature;name=smime.p7sContent-Transfer-Encoding: base64MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIPQzCCBN0wggPFoAMCAQICEHGS++YZX6xNEoV0cTSiGKcwDQYJKoZIhvcNAQEFBQAwezELMAkGA1UEBhMCR0IxGzAZBgNVBAgMEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBwwHU2FsZm9yZDEaMBgGA1UECgwRQ29tb2RvIENBIExpbWl0ZWQxITAfBgNVBAMMGEFBQSBDZXJ0aWZpY2F0ZSBTZXJ2aWNlczAeFw0wNDAxMDEwMDAwMDBaFw0yODEyMzEyMzU5NTlaMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsjmFpPJ9q0E7YkY3rs3BYHW8OWX5ShpHornMSMxqmNVNNRm5pELlzkniii8efNIxB8dOtINknS4p1aJkxIW9hVE1eaROaJB7HHqkkqgX8pgV8pPMyaQylbsMTzC9mKALi+VuG6JG+ni8om+rWV6lL8/K2m2qL+usobNqqrcuZzWLeeEeaYji5kbNoKXqvgvOdjp6Dpvq/NonWz1zHyLmSGHGTPNpsaguG7bUMSAsvIKKjqQOpdeJQ/wWWq8dcdcRWdq6hw2v+vPhwvCkxWeM1tZUOt4KpLoDd7NlyP0e03RiqhjKaJMeoYV+9Udly/hNVyh00jT/MLbu9mIwFIws6wIDAQABo4IBJzCCASMwHwYDVR0jBBgwFoAUoBEKIz6W8Qfs4q8p74Klf9AwpLQwHQYDVR0OBBYEFImCZ33EnSZwAEu0UEh83j2uBG59MA4GA1UdDwEB/wQEAwIBBjAPBgNVHRMBAf8EBTADAQH/MB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDARBgNVHSAECjAIMAYGBFUdIAAwewYDVR0fBHQwcjA4oDagNIYyaHR0cDovL2NybC5jb21vZG9jYS5jb20vQUFBQ2VydGlmaWNhdGVTZXJ2aWNlcy5jcmwwNqA0oDKGMGh0dHA6Ly9jcmwuY29tb2RvLm5ldC9BQUFDZXJ0aWZpY2F0ZVNlcnZpY2VzLmNybDARBglghkgBhvhCAQEEBAMCAQYwDQYJKoZIhvcNAQEFBQADggEBAJ2Vyzy4fqUJxB6/C8LHdo45PJTGEKpPDMngq4RdiVTgZTvzbRx8NywlVF+WIfw3hJGdFdwUT4HPVB1rbEVgxy35l1FM+WbKPKCCjKbI8OLp1Er57D9Wyd12jMOCAU9sAPMeGmF0BEcDqcZAV5G8ZSLFJ2dPV9tkWtmNH7qGL/QGrpxp7en0zykX2OBKnxogL5dMUbtGB8SKN04g4wkxaMeexIud6H4RvDJoEJYRmETYKlFgTYjrdDrfQwYyyDlWjDoRUtNBpEMD9O3vMyfbOeAUTibJ2PU54om4k123KSZB6rObroP8d3XK6Mq1/uJlSmM+RMTQw16Hc6mYHK9/FX8wggUaMIIEAqADAgECAhBtGeqnGU9qMyLmIjJ6qnHeMA0GCSqGSIb3DQEBBQUAMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMB4XDTExMDQyODAwMDAwMFoXDTIwMDUzMDEwNDgzOFowgZMxCzAJBgNVBAYTAkdCMRswGQYDVQQIExJHcmVhdGVyIE1hbmNoZXN0ZXIxEDAOBgNVBAcTB1NhbGZvcmQxGjAYBgNVBAoTEUNPTU9ETyBDQSBMaW1pdGVkMTkwNwYDVQQDEzBDT01PRE8gQ2xpZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBTZWN1cmUgRW1haWwgQ0EwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCShIRbS1eY1F4vi6ThQMijU1hfZmXxMk73nzJ9VdB4TFW3QpTg+SdxB8XGaaS5MsTxQBqQzCdWYn8XtXFpruUgG+TLY15gyqJB9mrho/+43x9IbWVDjCouK2M4d9+xF6zC2oIC1tQyatRnbyATj1w1+uVUgK/YcQodNwoCUFNslR2pEBS0mZVZEjH/CaLSTNxS297iQAFbSGjdxUq04O0kHzqvcV8H46y/FDuwJXFoPfQP1hdYRhWBPGiLi4MPbXohV+Y0sNsyfuNK4aVScmQmkU6lkg//4LFg/RpvaFGZY40ai6XMQpubfSJj06mg/M6ekN9EGfRcWzW6FvOnm//BAgMBAAGjggFLMIIBRzAfBgNVHSMEGDAWgBSJgmd9xJ0mcABLtFBIfN49rgRufTAdBgNVHQ4EFgQUehNOAHRbxnhjZCfBL+KgW7x5xXswDgYDVR0PAQH/BAQDAgEGMBIGA1UdEwEB/wQIMAYBAf8CAQAwEQYDVR0gBAowCDAGBgRVHSAAMFgGA1UdHwRRME8wTaBLoEmGR2h0dHA6Ly9jcmwudXNlcnRydXN0LmNvbS9VVE4tVVNFUkZpcnN0LUNsaWVudEF1dGhlbnRpY2F0aW9uYW5kRW1haWwuY3JsMHQGCCsGAQUFBwEBBGgwZjA9BggrBgEFBQcwAoYxaHR0cDovL2NydC51c2VydHJ1c3QuY29tL1VUTkFkZFRydXN0Q2xpZW50X0NBLmNydDAlBggrBgEFBQcwAYYZaHR0cDovL29jc3AudXNlcnRydXN0LmNvbTANBgkqhkiG9w0BAQUFAAOCAQEAhda+eFdVbTN/RFL+QtUGqAEDgIr7DbL9Sr/2r0FJ9RtaxdKtG3NuPukmfOZMmMEwKN/L+0I8oSU+CnXW0D05hmbRoZu1TZtvryhsHa/l6nRaqNqxwPF1ei+eupN5yv7ikR5WdLL4jdPgQ3Ib7Y/9YDkgR/uLrzplSDyYPaUlv73vYOBJ5RbI6z9Dg/Dg7g3B080zX5vQvWBqszv++tTJOjwf7Zv/m0kzvkIpOYPuM2kugp1FTahp2oAbHj3SGl18R5mlmwhtEpmG1l1XBxunML5LSUS4kH7K0Xk467Qz+qA6XSZYnmFVGLQh1ZnV4ENAQjC+6qXnlNKw/vN1+X9u5zCCBUAwggQooAMCAQICEQDFbZXOe/tmBQPtCFqj0aAHMA0GCSqGSIb3DQEBBQUAMIGTMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDE5MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBMB4XDTEzMDgxODAwMDAwMFoXDTE0MDgxODIzNTk1OVowMDEuMCwGCSqGSIb3DQEJARYfY2hyaXN0b3BoZS5iaWxsaW90dGV0QHdlYmRuYS51czCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAO93Fui94Ico9o81FVnISpmdw/yKmd3s1HNY9v+NQGlNOzMg6XYjuvSepfX4tmXhfid401iK9tuJT2yupu918FbeI5HdG3s5NWOUdABqb4z61g8H8yGsqFwaLlDkmBgI1DE4whCX/e+3E4CVl/6YfK7S5rWd2Ia/4K/s8GdGJNJCZOjaqteHAZZvC90RIdB2NCgZ2rbZDSLVS2f9NfLp+rX0PVBmol9fIXC+AtmNLFR8FhTw5iQrQCcKkxaz82AEGbQv5viz5rfQG4tCGqQJ71bSo0+JynuYIgn4KJNfcX0QMjJ3Fe7AlSRnnMF3m1k+uoR44i6F3sBY23wmfxNrK/8CAwEAAaOCAe8wggHrMB8GA1UdIwQYMBaAFHoTTgB0W8Z4Y2QnwS/ioFu8ecV7MB0GA1UdDgQWBBRO7fSdNIXhi9FJa1vqp12NuXl8PTAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADAgBgNVHSUEGTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZIAYb4QgEBBAQDAgUgMEYGA1UdIAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJlLmNvbW9kby5uZXQvQ1BTMFcGA1UdHwRQME4wTKBKoEiGRmh0dHA6Ly9jcmwuY29tb2RvY2EuY29tL0NPTU9ET0NsaWVudEF1dGhlbnRpY2F0aW9uYW5kU2VjdXJlRW1haWxDQS5jcmwwgYgGCCsGAQUFBwEBBHwwejBSBggrBgEFBQcwAoZGaHR0cDovL2NydC5jb21vZG9jYS5jb20vQ09NT0RPQ2xpZW50QXV0aGVudGljYXRpb25hbmRTZWN1cmVFbWFpbENBLmNydDAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuY29tb2RvY2EuY29tMCoGA1UdEQQjMCGBH2NocmlzdG9waGUuYmlsbGlvdHRldEB3ZWJkbmEudXMwDQYJKoZIhvcNAQEFBQADggEBABnxNy9MQe+JW8++bsQBGoMEDFwr1SpYH45cZWkuulj3kRiGM+4uz1DLpSsr/3GjFz8WAHhGjwaAlB0WpmWfYzjh+IUkRfQqiwMKdgBd+bDKVWE6asZKn406sdvgt10IFW+Vs6drYDqe+iVFxYYOAdU71S+Q9YWgVrtg5fUgDk3iruDsRnM1nrgI2hCSUmgb6oWLEi50NGuxBN2vC/ZSTn/Ptj1IP9XsV9F+SlZRsc3qfaRnr67XIkpjfg/PRfNg7l4CZm4ceDHr7ZpfG5tWU2tPKcrBA2HIopmch1Sqd48r/EZ2Z2h7nSqY3M8LBQnybTa8sNb8+8SllARs2DdcP0AxggOuMIIDqgIBATCBqTCBkzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGllbnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcwCQYFKw4DAhoFAKCCAdkwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTMxMDAyMDgxMDQyWjAjBgkqhkiG9w0BCQQxFgQUKAcBB7nydmBCrcy3y6ZvPnM7IsMwgboGCSsGAQQBgjcQBDGBrDCBqTCBkzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGllbnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcwgbwGCyqGSIb3DQEJEAILMYGsoIGpMIGTMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDE5MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBAhEAxW2Vznv7ZgUD7Qhao9GgBzANBgkqhkiG9w0BAQEFAASCAQAbHKn2o26oShJeuB849DFjKI3txx7DnOwG9kNF2xGTw2y5bMBzlTWVmbESrimWCoDI45N/pLVKEYjl+ruYU0dW55uXHI1sKVl4Y8f2KwQBU3Yvz8uM9+b+knFk4hS56GGG3yIOgz3669U+O4Wd7CjVs9+LcbNFQshg6Sb6ZoTSU6+lS3xH2O/cKqzdt92zdu1gysRizfv9djkCF9IQqSxs30WztySHmTnxM5gKS7odPrPRiM+B7w8NKcbTxtxL28xw1ugVuLvBEGRIngrKqhtWmPtjLF6TkNRIwSiFCVRaAfWFXrGuMVx7GPCqRbgeA0qMugg5fD35Nh2Hq3LwQsxSAAAAAAAA--Apple-Mail=_0EE23578-8F87-48DD-9AD0-9BCE7636AD7D--
Associated Messages, from the most recent to the oldest:
--Apple-Mail=_0EE23578-8F87-48DD-9AD0-9BCE7636AD7DContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=windows-1252Hi Palle! you do not specify what version of WebDNA you are using. You =might remember that the server version (6.2), even when the =configuration preferences shows "Commit Databases: Only commit databases =to disk when instructed", WebDNA will anyway writes your base to disk: =264MB takes time to write.In this case, there is the solution to split your database: let's say by =categories. If you have about 20 categories, you could split your =database in 20 parts. If you want to enter a new item in a specific =category, then a short code will point WebDNA at the proper database, =that will take about 20 times faster to update. I used this method to =build a 14 million record database and got fast results: using the first =letter of each customer name and 26 databases=85 this method is used by =Google in their search algorithm: your request first hits a server that ="knows" which other server to search for an answer.=20Another point is WebDNA FastCGI: WebDNA FastCGI writes to RAM if you =check "Only commit databases to disk when instructed", which is much =faster.- chrisOn Oct 2, 2013, at 10:41 AM, Palle Bo Nielsen =wrote:> Hi all,>=20> Looking for advise to optimise a webpage using WebDNA and large DB's.>=20> I have built a forum entirely in WebDNA and the DB's are getting big. =The main DB has the following characteristics=85>=20> - Columns: 11> - Rows: 847.121> - Size: 264 MB>=20> If I display the different generic topics within the Forum and the =most recent Post within each category etc. then the code is executing =quite fast (acceptable performance).>=20> But if I want to add the value of posts within each category or within =each thread then the performance is slowing the too much.>=20> I have a category DB which eventually show 25 topics on the main page =of the forum, then I do a search into the main DB and search for all =posts with this categories ID and show the numFound. This is repeated =for every unique Topic.>=20>=20>=20> << Searching for the Topics >>> [search =db=3D/forum/db/db1.db&eqdb1_publishdata=3D1&asdb1_prioritysort=3D1&db1_pri=oritytype=3Dnum&AllReqd=3DT][founditems]>=20> << Searching for the numFound Value - This One is Pulling a Lot of =Performance even though it's simple, but there is a lot of data to =search through >>> [search =db=3D/forum/db/db4.db&eqdb4_publishdata=3D1&eqdb4_db1data=3D[db1_sku]&AllR=eqd=3DT][numFound][founditems][/founditems][/search]>=20>=20>=20> I would appreciate any good advise or ideas on how to accelerate the =performance. Some kind of indexing to avoid live searching would be =great, but how?>=20> /Palle>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us--Apple-Mail=_0EE23578-8F87-48DD-9AD0-9BCE7636AD7DContent-Disposition: attachment;filename=smime.p7sContent-Type: application/pkcs7-signature;name=smime.p7sContent-Transfer-Encoding: base64MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIPQzCCBN0wggPFoAMCAQICEHGS++YZX6xNEoV0cTSiGKcwDQYJKoZIhvcNAQEFBQAwezELMAkGA1UEBhMCR0IxGzAZBgNVBAgMEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBwwHU2FsZm9yZDEaMBgGA1UECgwRQ29tb2RvIENBIExpbWl0ZWQxITAfBgNVBAMMGEFBQSBDZXJ0aWZpY2F0ZSBTZXJ2aWNlczAeFw0wNDAxMDEwMDAwMDBaFw0yODEyMzEyMzU5NTlaMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsjmFpPJ9q0E7YkY3rs3BYHW8OWX5ShpHornMSMxqmNVNNRm5pELlzkniii8efNIxB8dOtINknS4p1aJkxIW9hVE1eaROaJB7HHqkkqgX8pgV8pPMyaQylbsMTzC9mKALi+VuG6JG+ni8om+rWV6lL8/K2m2qL+usobNqqrcuZzWLeeEeaYji5kbNoKXqvgvOdjp6Dpvq/NonWz1zHyLmSGHGTPNpsaguG7bUMSAsvIKKjqQOpdeJQ/wWWq8dcdcRWdq6hw2v+vPhwvCkxWeM1tZUOt4KpLoDd7NlyP0e03RiqhjKaJMeoYV+9Udly/hNVyh00jT/MLbu9mIwFIws6wIDAQABo4IBJzCCASMwHwYDVR0jBBgwFoAUoBEKIz6W8Qfs4q8p74Klf9AwpLQwHQYDVR0OBBYEFImCZ33EnSZwAEu0UEh83j2uBG59MA4GA1UdDwEB/wQEAwIBBjAPBgNVHRMBAf8EBTADAQH/MB0GA1UdJQQWMBQGCCsGAQUFBwMCBggrBgEFBQcDBDARBgNVHSAECjAIMAYGBFUdIAAwewYDVR0fBHQwcjA4oDagNIYyaHR0cDovL2NybC5jb21vZG9jYS5jb20vQUFBQ2VydGlmaWNhdGVTZXJ2aWNlcy5jcmwwNqA0oDKGMGh0dHA6Ly9jcmwuY29tb2RvLm5ldC9BQUFDZXJ0aWZpY2F0ZVNlcnZpY2VzLmNybDARBglghkgBhvhCAQEEBAMCAQYwDQYJKoZIhvcNAQEFBQADggEBAJ2Vyzy4fqUJxB6/C8LHdo45PJTGEKpPDMngq4RdiVTgZTvzbRx8NywlVF+WIfw3hJGdFdwUT4HPVB1rbEVgxy35l1FM+WbKPKCCjKbI8OLp1Er57D9Wyd12jMOCAU9sAPMeGmF0BEcDqcZAV5G8ZSLFJ2dPV9tkWtmNH7qGL/QGrpxp7en0zykX2OBKnxogL5dMUbtGB8SKN04g4wkxaMeexIud6H4RvDJoEJYRmETYKlFgTYjrdDrfQwYyyDlWjDoRUtNBpEMD9O3vMyfbOeAUTibJ2PU54om4k123KSZB6rObroP8d3XK6Mq1/uJlSmM+RMTQw16Hc6mYHK9/FX8wggUaMIIEAqADAgECAhBtGeqnGU9qMyLmIjJ6qnHeMA0GCSqGSIb3DQEBBQUAMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMB4XDTExMDQyODAwMDAwMFoXDTIwMDUzMDEwNDgzOFowgZMxCzAJBgNVBAYTAkdCMRswGQYDVQQIExJHcmVhdGVyIE1hbmNoZXN0ZXIxEDAOBgNVBAcTB1NhbGZvcmQxGjAYBgNVBAoTEUNPTU9ETyBDQSBMaW1pdGVkMTkwNwYDVQQDEzBDT01PRE8gQ2xpZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBTZWN1cmUgRW1haWwgQ0EwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCShIRbS1eY1F4vi6ThQMijU1hfZmXxMk73nzJ9VdB4TFW3QpTg+SdxB8XGaaS5MsTxQBqQzCdWYn8XtXFpruUgG+TLY15gyqJB9mrho/+43x9IbWVDjCouK2M4d9+xF6zC2oIC1tQyatRnbyATj1w1+uVUgK/YcQodNwoCUFNslR2pEBS0mZVZEjH/CaLSTNxS297iQAFbSGjdxUq04O0kHzqvcV8H46y/FDuwJXFoPfQP1hdYRhWBPGiLi4MPbXohV+Y0sNsyfuNK4aVScmQmkU6lkg//4LFg/RpvaFGZY40ai6XMQpubfSJj06mg/M6ekN9EGfRcWzW6FvOnm//BAgMBAAGjggFLMIIBRzAfBgNVHSMEGDAWgBSJgmd9xJ0mcABLtFBIfN49rgRufTAdBgNVHQ4EFgQUehNOAHRbxnhjZCfBL+KgW7x5xXswDgYDVR0PAQH/BAQDAgEGMBIGA1UdEwEB/wQIMAYBAf8CAQAwEQYDVR0gBAowCDAGBgRVHSAAMFgGA1UdHwRRME8wTaBLoEmGR2h0dHA6Ly9jcmwudXNlcnRydXN0LmNvbS9VVE4tVVNFUkZpcnN0LUNsaWVudEF1dGhlbnRpY2F0aW9uYW5kRW1haWwuY3JsMHQGCCsGAQUFBwEBBGgwZjA9BggrBgEFBQcwAoYxaHR0cDovL2NydC51c2VydHJ1c3QuY29tL1VUTkFkZFRydXN0Q2xpZW50X0NBLmNydDAlBggrBgEFBQcwAYYZaHR0cDovL29jc3AudXNlcnRydXN0LmNvbTANBgkqhkiG9w0BAQUFAAOCAQEAhda+eFdVbTN/RFL+QtUGqAEDgIr7DbL9Sr/2r0FJ9RtaxdKtG3NuPukmfOZMmMEwKN/L+0I8oSU+CnXW0D05hmbRoZu1TZtvryhsHa/l6nRaqNqxwPF1ei+eupN5yv7ikR5WdLL4jdPgQ3Ib7Y/9YDkgR/uLrzplSDyYPaUlv73vYOBJ5RbI6z9Dg/Dg7g3B080zX5vQvWBqszv++tTJOjwf7Zv/m0kzvkIpOYPuM2kugp1FTahp2oAbHj3SGl18R5mlmwhtEpmG1l1XBxunML5LSUS4kH7K0Xk467Qz+qA6XSZYnmFVGLQh1ZnV4ENAQjC+6qXnlNKw/vN1+X9u5zCCBUAwggQooAMCAQICEQDFbZXOe/tmBQPtCFqj0aAHMA0GCSqGSIb3DQEBBQUAMIGTMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDE5MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBMB4XDTEzMDgxODAwMDAwMFoXDTE0MDgxODIzNTk1OVowMDEuMCwGCSqGSIb3DQEJARYfY2hyaXN0b3BoZS5iaWxsaW90dGV0QHdlYmRuYS51czCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAO93Fui94Ico9o81FVnISpmdw/yKmd3s1HNY9v+NQGlNOzMg6XYjuvSepfX4tmXhfid401iK9tuJT2yupu918FbeI5HdG3s5NWOUdABqb4z61g8H8yGsqFwaLlDkmBgI1DE4whCX/e+3E4CVl/6YfK7S5rWd2Ia/4K/s8GdGJNJCZOjaqteHAZZvC90RIdB2NCgZ2rbZDSLVS2f9NfLp+rX0PVBmol9fIXC+AtmNLFR8FhTw5iQrQCcKkxaz82AEGbQv5viz5rfQG4tCGqQJ71bSo0+JynuYIgn4KJNfcX0QMjJ3Fe7AlSRnnMF3m1k+uoR44i6F3sBY23wmfxNrK/8CAwEAAaOCAe8wggHrMB8GA1UdIwQYMBaAFHoTTgB0W8Z4Y2QnwS/ioFu8ecV7MB0GA1UdDgQWBBRO7fSdNIXhi9FJa1vqp12NuXl8PTAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIwADAgBgNVHSUEGTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZIAYb4QgEBBAQDAgUgMEYGA1UdIAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJlLmNvbW9kby5uZXQvQ1BTMFcGA1UdHwRQME4wTKBKoEiGRmh0dHA6Ly9jcmwuY29tb2RvY2EuY29tL0NPTU9ET0NsaWVudEF1dGhlbnRpY2F0aW9uYW5kU2VjdXJlRW1haWxDQS5jcmwwgYgGCCsGAQUFBwEBBHwwejBSBggrBgEFBQcwAoZGaHR0cDovL2NydC5jb21vZG9jYS5jb20vQ09NT0RPQ2xpZW50QXV0aGVudGljYXRpb25hbmRTZWN1cmVFbWFpbENBLmNydDAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuY29tb2RvY2EuY29tMCoGA1UdEQQjMCGBH2NocmlzdG9waGUuYmlsbGlvdHRldEB3ZWJkbmEudXMwDQYJKoZIhvcNAQEFBQADggEBABnxNy9MQe+JW8++bsQBGoMEDFwr1SpYH45cZWkuulj3kRiGM+4uz1DLpSsr/3GjFz8WAHhGjwaAlB0WpmWfYzjh+IUkRfQqiwMKdgBd+bDKVWE6asZKn406sdvgt10IFW+Vs6drYDqe+iVFxYYOAdU71S+Q9YWgVrtg5fUgDk3iruDsRnM1nrgI2hCSUmgb6oWLEi50NGuxBN2vC/ZSTn/Ptj1IP9XsV9F+SlZRsc3qfaRnr67XIkpjfg/PRfNg7l4CZm4ceDHr7ZpfG5tWU2tPKcrBA2HIopmch1Sqd48r/EZ2Z2h7nSqY3M8LBQnybTa8sNb8+8SllARs2DdcP0AxggOuMIIDqgIBATCBqTCBkzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGllbnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcwCQYFKw4DAhoFAKCCAdkwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTMxMDAyMDgxMDQyWjAjBgkqhkiG9w0BCQQxFgQUKAcBB7nydmBCrcy3y6ZvPnM7IsMwgboGCSsGAQQBgjcQBDGBrDCBqTCBkzELMAkGA1UEBhMCR0IxGzAZBgNVBAgTEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBxMHU2FsZm9yZDEaMBgGA1UEChMRQ09NT0RPIENBIExpbWl0ZWQxOTA3BgNVBAMTMENPTU9ETyBDbGllbnQgQXV0aGVudGljYXRpb24gYW5kIFNlY3VyZSBFbWFpbCBDQQIRAMVtlc57+2YFA+0IWqPRoAcwgbwGCyqGSIb3DQEJEAILMYGsoIGpMIGTMQswCQYDVQQGEwJHQjEbMBkGA1UECBMSR3JlYXRlciBNYW5jaGVzdGVyMRAwDgYDVQQHEwdTYWxmb3JkMRowGAYDVQQKExFDT01PRE8gQ0EgTGltaXRlZDE5MDcGA1UEAxMwQ09NT0RPIENsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgU2VjdXJlIEVtYWlsIENBAhEAxW2Vznv7ZgUD7Qhao9GgBzANBgkqhkiG9w0BAQEFAASCAQAbHKn2o26oShJeuB849DFjKI3txx7DnOwG9kNF2xGTw2y5bMBzlTWVmbESrimWCoDI45N/pLVKEYjl+ruYU0dW55uXHI1sKVl4Y8f2KwQBU3Yvz8uM9+b+knFk4hS56GGG3yIOgz3669U+O4Wd7CjVs9+LcbNFQshg6Sb6ZoTSU6+lS3xH2O/cKqzdt92zdu1gysRizfv9djkCF9IQqSxs30WztySHmTnxM5gKS7odPrPRiM+B7w8NKcbTxtxL28xw1ugVuLvBEGRIngrKqhtWmPtjLF6TkNRIwSiFCVRaAfWFXrGuMVx7GPCqRbgeA0qMugg5fD35Nh2Hq3LwQsxSAAAAAAAA--Apple-Mail=_0EE23578-8F87-48DD-9AD0-9BCE7636AD7D--
christophe.billiottet@webdna.us
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:
CountChars (2004)
OT - Need A Good Address Parser (2000)
Classified (1999)
Preferred Web Design Tool? (1999)
rounding onlu UP (2002)
Uh...can someone help me out with the b10? (1997)
Custom WebCat Prefs ... (1997)
Re:trouble (1997)
Help with database strategy (1998)
FW: 2.01 upgrade problems (1997)
Execute Applescript (1997)
WebCatalog/WebMerchant 2.1 (1998)
Founditems (1998)
Strange Form Occurrence on Log In Pages (2005)
email list archive template (2004)
Exclude by date - multiple (1997)
Requiring that certain fields be completed (1997)
Tab Charactor (1997)
shipcost (1997)
Multiple Merchant Accounts? (1997)