What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

RequiredFields template (1997) Loops and [index] (1998) t or f (1997) User Defined Sorting (1997) WebCat2 - storing unformatted date data? (1997) [SearchString] usage (1997) [ShowIf] a either fields are blank (1998) AAgghh!! Help, please. SSL strikes again. (1997) showcart (2000) TaxRate and ShipCost Problem (1998) Not really WebCat (1997) Multiple Pulldowns (1997) This is an odd error (2001) Browser Problem?!? Still getting Error message using POST! (1997) Database Sizes (2000) Problem 2: Prefs file... (1997) Commitdatabase tag (1998) Summing fields (1997) Permissions (2000) [WebDNA] JSONStore Levels (2020)