Re: [WebDNA] Acceleratin Search / Index Performance in a Formum Service

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110760
interpreted = N
texte = --047d7ba975c89b2fb904e7bdcf01 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable SSD? Le 2 oct. 2013 10:02, "Palle Bo Nielsen" a =E9cr= it : > Hi Lawrence, > > HDD with 8GB RAM > > /Palle > > > On 02/10/2013, at 09.50, Lawrence Banahan wrote: > > Hi > Do you have SSD drives on your server with plenty of ram? > Lawrence > Le 2 oct. 2013 09:41, "Palle Bo Nielsen" 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. Th= e >> 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 f= ast >> (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 ever= y >> unique Topic. >> >> >> >> << Searching for the Topics >> >> [search >> db=3D/forum/db/db1.db&eqdb1_publishdata=3D1&asdb1_prioritysort=3D1&db1_p= rioritytype=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 searc= h >> through >> >> [search >> db=3D/forum/db/db4.db&eqdb4_publishdata=3D1&eqdb4_db1data=3D[db1_sku]&Al= lReqd=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 grea= t, >> 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 >> > --------------------------------------------------------- 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.u= s > **** > > > --------------------------------------------------------- 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.u= s --047d7ba975c89b2fb904e7bdcf01 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable

SSD?

Le 2 oct. 2013 10:02, "Palle Bo Nielsen&quo= t; <powerpalle@powerpalle.dk= > a =E9crit :
Hi Lawrence,

<= div>HDD with 8GB RAM

/Palle

On 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?
Lawrence

Le 2 oct. 2013 09:41, "Palle Bo Nielsen&quo= t; <powerp= alle@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 <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
--------------------------------------------------------- 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: suppo= rt@webdna.us

--------------------------------------------------------- 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: suppo= rt@webdna.us
--047d7ba975c89b2fb904e7bdcf01-- 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)
--047d7ba975c89b2fb904e7bdcf01 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable SSD? Le 2 oct. 2013 10:02, "Palle Bo Nielsen" a =E9cr= it : > Hi Lawrence, > > HDD with 8GB RAM > > /Palle > > > On 02/10/2013, at 09.50, Lawrence Banahan wrote: > > Hi > Do you have SSD drives on your server with plenty of ram? > Lawrence > Le 2 oct. 2013 09:41, "Palle Bo Nielsen" 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. Th= e >> 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 f= ast >> (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 ever= y >> unique Topic. >> >> >> >> << Searching for the Topics >> >> [search >> db=3D/forum/db/db1.db&eqdb1_publishdata=3D1&asdb1_prioritysort=3D1&db1_p= rioritytype=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 searc= h >> through >> >> [search >> db=3D/forum/db/db4.db&eqdb4_publishdata=3D1&eqdb4_db1data=3D[db1_sku]&Al= lReqd=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 grea= t, >> 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 >> > --------------------------------------------------------- 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.u= s > **** > > > --------------------------------------------------------- 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.u= s --047d7ba975c89b2fb904e7bdcf01 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable

SSD?

Le 2 oct. 2013 10:02, "Palle Bo Nielsen&quo= t; <powerpalle@powerpalle.dk= > a =E9crit :
Hi Lawrence,

<= div>HDD with 8GB RAM

/Palle

On 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?
Lawrence

Le 2 oct. 2013 09:41, "Palle Bo Nielsen&quo= t; <powerp= alle@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 <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
--------------------------------------------------------- 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: suppo= rt@webdna.us

--------------------------------------------------------- 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: suppo= rt@webdna.us
--047d7ba975c89b2fb904e7bdcf01-- 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:

off topic - dna snipets (1997) ShowIf helper? (1998) Locking up with WebCatalog... (1997) Using Protection =) (2003) Re:multiple digests, please stop (1997) Not Authorised Adding Items (1998) Problem with updating 2.1b7 -> 2.1.1 (1998) emailer (1997) Cart Question (1998) 'does not contain' operator needed ... (1997) Help! WebCat2 bug (1997) Trigger Admin acting up (2001) Re:E-mailer application times out (1998) WC TableGrinder (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Sort Order on a page search (1997) & Aftermath (1999) Can't access [OrderFile] OSXS WC4 (2000) Nested [tags] (2001) select multiple 2 more cents (1997)