[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 MB 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). 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 MB 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). 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:
Resume Catalog ? (1997)
A multi-processor savvy WebCatalog? (1997)
Forcing Paragraph Breaks on Results (1998)
Shopping Cart Problem (1998)
executive server side java within webDNA (1997)
Giving out error pages (1997)
Field name-subcategory (1997)
WebCat2: Items xx to xx shown, etc. (1997)
SubCategorizing (2000)
_ in front of field name (1998)
NetSplat and WebCat2 (1997)
Multiple catalog databases and showcart (1997)
Make sure I understand this??? (1997)
[WebDNA] WebDNA Email Auth Functioning? (2014)
SiteGuard Admin Feature ? (1997)
FORMS: Returning a specific page (1997)
PCS Frames (1997)
Summing fields (1997)
[LOOKUP] (1997)
Whats going on with my SERIAL NUMBER??? (1998)