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:

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)