SSD?
Hi Lawrence,<=div>HDD with 8GB RAM/Palle---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: suppo=rt@webdna.usOn 02/10/2013, at 09.50, Lawrence Banahan <banahan.l@gmail.com> wrote:<=/div>Hi
Do you have SSD drives on your server with plenty of ram?
LawrenceLe 2 oct. 2013 09:41, "Palle Bo Nielsen&quo=t; <powerp=alle@powerpalle.dk> a =E9crit :---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: suppo=rt@webdna.usHi 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. T=he 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 rec=ent Post within each category etc. then the code is executing quite fast (a=cceptable 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 th=e 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_prioritys=ort=3D1&db1_prioritytype=3Dnum&AllReqd=3DT][founditems]
<< Searching for the numFound Value - This One is Pulling a Lot of Pe=rformance 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]&AllReqd=3DT][numFound][founditems][/founditems][/search]
I would appreciate any good advise or ideas on how to accelerate the perfor=mance. Some kind of indexing to avoid live searching would be great, but ho=w?
/Palle
---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <ta=lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: suppo=rt@webdna.us
SSD?
Hi Lawrence,<=div>HDD with 8GB RAM/Palle---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: suppo=rt@webdna.usOn 02/10/2013, at 09.50, Lawrence Banahan <banahan.l@gmail.com> wrote:<=/div>Hi
Do you have SSD drives on your server with plenty of ram?
LawrenceLe 2 oct. 2013 09:41, "Palle Bo Nielsen&quo=t; <powerp=alle@powerpalle.dk> a =E9crit :---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: suppo=rt@webdna.usHi 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. T=he 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 rec=ent Post within each category etc. then the code is executing quite fast (a=cceptable 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 th=e 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_prioritys=ort=3D1&db1_prioritytype=3Dnum&AllReqd=3DT][founditems]
<< Searching for the numFound Value - This One is Pulling a Lot of Pe=rformance 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]&AllReqd=3DT][numFound][founditems][/founditems][/search]
I would appreciate any good advise or ideas on how to accelerate the perfor=mance. Some kind of indexing to avoid live searching would be great, but ho=w?
/Palle
---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <ta=lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: suppo=rt@webdna.us
DOWNLOAD WEBDNA NOW!
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...