Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110757
interpreted = N
texte = --e89a8f50350ee5b60704e7bd5202Content-Type: text/plain; charset=windows-1252Content-Transfer-Encoding: quoted-printableHiDo you have SSD drives on your server with plenty of ram?LawrenceLe 2 oct. 2013 09:41, "Palle Bo Nielsen"
a =E9cr=it:> 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 fa=st> (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_pr=ioritytype=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]&All=Reqd=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>> ---------------------------------------------------------> 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>--e89a8f50350ee5b60704e7bd5202Content-Type: text/html; charset=windows-1252Content-Transfer-Encoding: quoted-printableHi
Do you have SSD drives on your server with plenty of ram?
Lawrence
Le 2 oct. 2013 09:41, "Palle Bo Nielsen&quo=t; <
powerpalle@powerpalle.dk=> a =E9crit :
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. 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 <talk@webdna.us&g=t;.
To unsubscribe, E-mail to: <talk=-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us
--e89a8f50350ee5b60704e7bd5202--
Associated Messages, from the most recent to the oldest:
--e89a8f50350ee5b60704e7bd5202Content-Type: text/plain; charset=windows-1252Content-Transfer-Encoding: quoted-printableHiDo you have SSD drives on your server with plenty of ram?LawrenceLe 2 oct. 2013 09:41, "Palle Bo Nielsen" a =E9cr=it:> 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 fa=st> (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_pr=ioritytype=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]&All=Reqd=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>> ---------------------------------------------------------> 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>--e89a8f50350ee5b60704e7bd5202Content-Type: text/html; charset=windows-1252Content-Transfer-Encoding: quoted-printableHi
Do you have SSD drives on your server with plenty of ram?
Lawrence
Le 2 oct. 2013 09:41, "Palle Bo Nielsen&quo=t; <
powerpalle@powerpalle.dk=> a =E9crit :
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. 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 <talk@webdna.us&g=t;.
To unsubscribe, E-mail to: <talk=-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us
--e89a8f50350ee5b60704e7bd5202--
Lawrence Banahan
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:
TRAINING videos - Prove IT. (1998)
WebCat2b13MacPlugIn - More limits on [include] (1997)
ISAPI WC6a and Windows 2003 Web Edition (2006)
WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997)
New site announcement + Showing once on a founditems (1997)
Questions on Mac WC 3.0.5b13 (2000)
[OT] Airport Network (2003)
Practice runs ? (1997)
[WebDNA] weekday question (2013)
Kaaaaahhhhhhhnnnnnnn! (1997)
Passing WebCat data to SSL server (1997)
NT vs Mac (1997)
Update quantity (2000)
Cart Numbers (1997)
Merging databases (1997)
problems with 2 tags (1997)
BUG REPORT -- Refusing connections! (1999)
Country & Ship-to address & other fields ? (1997)
& problem (1999)
Applescript Hack (1996)