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

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110763
interpreted = N
texte = --047d7b15adffe3f93404e7be292c Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable I swap my hard drive to SSD on an old G5 server and I had =E0 realy great boost But creating Index fir your cb would also increasse your search speed Lawrence Le 2 oct. 2013 10:47, "Palle Bo Nielsen" a =E9cr= it : > No, HDD > > /Palle > > > > On 02/10/2013, at 10.25, Lawrence Banahan wrote: > > SSD? > Le 2 oct. 2013 10:02, "Palle Bo Nielsen" a > =E9crit : > >> 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. >>> 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 = fast >>> (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 o= f >>> 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 eve= ry >>> unique Topic. >>> >>> >>> >>> << Searching for the Topics >> >>> [search >>> db=3D/forum/db/db1.db&eqdb1_publishdata=3D1&asdb1_prioritysort=3D1&db1_= prioritytype=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 sear= ch >>> through >> >>> [search >>> db=3D/forum/db/db4.db&eqdb4_publishdata=3D1&eqdb4_db1data=3D[db1_sku]&A= llReqd=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 gre= at, >>> 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 i= s >> 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 i= s >> 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 --047d7b15adffe3f93404e7be292c Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable

I swap my hard drive to SSD on an old G5 server and I had = =E0 realy great boost
But creating Index fir your cb would also increasse your search speed
Lawrence

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

/Palle
=



On 02/10/2013, at 10.25, L= awrence Banahan <banahan.l@gmail.com> wrote:

SSD?

Le 2 oct. 2013 10:02, "Palle Bo Nielsen&quo= t; <powerp= alle@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
--------------------------------------------------------- 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
--047d7b15adffe3f93404e7be292c-- 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)
--047d7b15adffe3f93404e7be292c Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable I swap my hard drive to SSD on an old G5 server and I had =E0 realy great boost But creating Index fir your cb would also increasse your search speed Lawrence Le 2 oct. 2013 10:47, "Palle Bo Nielsen" a =E9cr= it : > No, HDD > > /Palle > > > > On 02/10/2013, at 10.25, Lawrence Banahan wrote: > > SSD? > Le 2 oct. 2013 10:02, "Palle Bo Nielsen" a > =E9crit : > >> 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. >>> 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 = fast >>> (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 o= f >>> 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 eve= ry >>> unique Topic. >>> >>> >>> >>> << Searching for the Topics >> >>> [search >>> db=3D/forum/db/db1.db&eqdb1_publishdata=3D1&asdb1_prioritysort=3D1&db1_= prioritytype=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 sear= ch >>> through >> >>> [search >>> db=3D/forum/db/db4.db&eqdb4_publishdata=3D1&eqdb4_db1data=3D[db1_sku]&A= llReqd=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 gre= at, >>> 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 i= s >> 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 i= s >> 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 --047d7b15adffe3f93404e7be292c Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable

I swap my hard drive to SSD on an old G5 server and I had = =E0 realy great boost
But creating Index fir your cb would also increasse your search speed
Lawrence

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

/Palle
=



On 02/10/2013, at 10.25, L= awrence Banahan <banahan.l@gmail.com> wrote:

SSD?

Le 2 oct. 2013 10:02, "Palle Bo Nielsen&quo= t; <powerp= alle@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
--------------------------------------------------------- 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
--047d7b15adffe3f93404e7be292c-- 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:

mac hack (1997) AAgghh!! Help, please. SSL strikes again. (1997) Getting Total Quantity (1997) FORMS: Returning a specific page (1997) CSV import suggestions (2007) OT: Web Cams (2003) Running _every_ page through WebCat-error.html (1997) raw field names (2001) Calculating multiple shipping... (1997) can you take a look (2003) NetSplat and WebCat2 (1997) Summing fields (1997) encryption madness (2003) Keep away (1997) Restart of DBserver (1997) using showpage and showcart commands (1996) WebCatalog2 for NT Beta Request (1997) Changing in a founditems tag (1999) NT Manual (1997) [group] ? (1997)