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 = --e89a8f50350ee5b60704e7bd5202 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi Do you have SSD drives on your server with plenty of ram? Lawrence Le 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 > --e89a8f50350ee5b60704e7bd5202 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable

Hi
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:

    
  1. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Donovan Brooke 2013)
  2. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Palle Bo Nielsen 2013)
  3. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Palle Bo Nielsen 2013)
  4. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Lawrence Banahan 2013)
  5. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Palle Bo Nielsen 2013)
  6. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Lawrence Banahan 2013)
  7. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Palle Bo Nielsen 2013)
  8. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (matt@psiprime.com 2013)
  9. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Lawrence Banahan 2013)
  10. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (christophe.billiottet@webdna.us 2013)
  11. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Palle Bo Nielsen 2013)
  12. Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Lawrence Banahan 2013)
  13. [WebDNA] Acceleratin Search / Index Performance in a Formum Service (Palle Bo Nielsen 2013)
--e89a8f50350ee5b60704e7bd5202 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi Do you have SSD drives on your server with plenty of ram? Lawrence Le 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 > --e89a8f50350ee5b60704e7bd5202 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable

Hi
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:

Limitations on fields? Server is crashing (1997) Webcat run amuk (2002) NT Version on IIS 4.0 (1997) Webcat 2.0.1 date math bug -> Crash! (1997) Why is my easy [AddLineItems] NOT working?? (2000) [UPPERCASE] (1997) Bug? (1997) date sorting and 'template (1997) Requiring that certain fields be completed (1997) Extra equals signs with IE? (More debugging questions...) (1997) 2nd WebCatalog2 Feature Request (1996) multiple selected Checkboxes (1998) Webten&Webcat (1998) WCS Newbie question (1997) two domains and one cart and database (2000) Email within tmpl ? (1997) Works! (1997) Categorizing by data (2001) Fun with Dates - revisited (1997) Setting up shop (1997)