[WebDNA] Acceleratin Search / Index Performance in a Formum Service
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110756
interpreted = N
texte = Hi all,Looking for advise to optimise a webpage using WebDNA and large DB's.I have built a forum entirely in WebDNA and the DB's are getting big. =The main DB has the following characteristics=85- Columns: 11- Rows: 847.121- Size: 264 MBIf 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).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.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.<< Searching for the Topics >>[search =db=3D/forum/db/db1.db&eqdb1_publishdata=3D1&asdb1_prioritysort=3D1&db1_pri=oritytype=3Dnum&AllReqd=3DT][founditems]<< 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]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?/Palle
Associated Messages, from the most recent to the oldest:
Hi all,Looking for advise to optimise a webpage using WebDNA and large DB's.I have built a forum entirely in WebDNA and the DB's are getting big. =The main DB has the following characteristics=85- Columns: 11- Rows: 847.121- Size: 264 MBIf 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).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.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.<< Searching for the Topics >>[search =db=3D/forum/db/db1.db&eqdb1_publishdata=3D1&asdb1_prioritysort=3D1&db1_pri=oritytype=3Dnum&AllReqd=3DT]
[founditems]<< 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]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?/Palle
Palle Bo Nielsen
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:
Integrating Bar Codes with WebDNA (2006)
Adding Multiple Items to Shopping Cart from a Resultspage (1997)
OT: Amazon Patents (2000)
Here's how to kill a Butler Database. (1997)
Disappearing data [OT] (2002)
RE: Netscape v. IE (1997)
WebDNA and SQL (2003)
emailer (1997)
japanese characters (1997)
graphics server, SSL, Netscape 4.0 (off topic) (1998)
Sense/Disallow HTML tags during $Append (1997)
Secure server question (1997)
Random letter and/or number (2001)
search form problem.. (1997)
Linebreak as a delimiter in listwords? (2003)
OT: JavaScript question (2001)
Add a field to the error log? (1997)
carriage returns in data (1997)
comparison to Lasso 6 or 7 (2004)
fixed date problem (1997)