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

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110758
interpreted = N
texte = --Apple-Mail=_167A6CCE-A494-47AF-89FF-04882095B3B6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 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 >=20 > Le 2 oct. 2013 09:41, "Palle Bo Nielsen" a = =E9crit : > Hi all, >=20 > Looking for advise to optimise a webpage using WebDNA and large DB's. >=20 > I have built a forum entirely in WebDNA and the DB's are getting big. = The main DB has the following characteristics=85 >=20 > - Columns: 11 > - Rows: 847.121 > - Size: 264 MB >=20 > 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). >=20 > 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. >=20 > 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. >=20 >=20 >=20 > << Searching for the Topics >> > [search = db=3D/forum/db/db1.db&eqdb1_publishdata=3D1&asdb1_prioritysort=3D1&db1_pri= oritytype=3Dnum&AllReqd=3DT][founditems] >=20 > << 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]&AllR= eqd=3DT][numFound][founditems][/founditems][/search] >=20 >=20 >=20 > 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? >=20 > /Palle >=20 > --------------------------------------------------------- > 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.us --Apple-Mail=_167A6CCE-A494-47AF-89FF-04882095B3B6 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252
Hi Lawrence,

HDD with 8GB = RAM

/Palle


On = 02/10/2013, at 09.50, Lawrence Banahan <banahan.l@gmail.com> = wrote:

Hi
Do you have SSD drives on your server with plenty of ram?
Lawrence

Le 2 oct. 2013 09:41, "Palle Bo Nielsen" = <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. = 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 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_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 = search through >>
[search = db=3D/forum/db/db4.db&eqdb4_publishdata=3D1&eqdb4_db1data=3D[db1_s= ku]&AllReqd=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 <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
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/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_167A6CCE-A494-47AF-89FF-04882095B3B6-- 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)
--Apple-Mail=_167A6CCE-A494-47AF-89FF-04882095B3B6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 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 >=20 > Le 2 oct. 2013 09:41, "Palle Bo Nielsen" a = =E9crit : > Hi all, >=20 > Looking for advise to optimise a webpage using WebDNA and large DB's. >=20 > I have built a forum entirely in WebDNA and the DB's are getting big. = The main DB has the following characteristics=85 >=20 > - Columns: 11 > - Rows: 847.121 > - Size: 264 MB >=20 > 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). >=20 > 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. >=20 > 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. >=20 >=20 >=20 > << Searching for the Topics >> > [search = db=3D/forum/db/db1.db&eqdb1_publishdata=3D1&asdb1_prioritysort=3D1&db1_pri= oritytype=3Dnum&AllReqd=3DT][founditems] >=20 > << 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]&AllR= eqd=3DT][numFound][founditems][/founditems][/search] >=20 >=20 >=20 > 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? >=20 > /Palle >=20 > --------------------------------------------------------- > 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.us --Apple-Mail=_167A6CCE-A494-47AF-89FF-04882095B3B6 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252
Hi Lawrence,

HDD with 8GB = RAM

/Palle


On = 02/10/2013, at 09.50, Lawrence Banahan <banahan.l@gmail.com> = wrote:

Hi
Do you have SSD drives on your server with plenty of ram?
Lawrence

Le 2 oct. 2013 09:41, "Palle Bo Nielsen" = <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. = 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 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_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 = search through >>
[search = db=3D/forum/db/db4.db&eqdb4_publishdata=3D1&eqdb4_db1data=3D[db1_s= ku]&AllReqd=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 <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
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/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_167A6CCE-A494-47AF-89FF-04882095B3B6-- Palle Bo Nielsen

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:

using showpage and showcart commands (1996) [WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011) Orderfile Encryption (2007) t or f (1997) [cart] not being interpreted inside [founditems] (1997) pc (1997) Tax & Shipping (1997) 2.0 Info (1997) Webcat issue (2006) Processing all html files through WebCat or Typhoon (1998) Searchable WebCat (etc.) Docs ? (1997) WCS Newbie question (1997) Not carrying Zero (2000) [SHOWIF AND/OR] (1997) Summ=T Problem (1997) New Command prefs ... (1997) Replace Statement (1997) 2.0 Info (1997) Upgrading old WebCat Database Files (1997) autocommit problem (1998)