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-04882095B3B6Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=windows-1252Hi Lawrence,HDD with 8GB RAM/PalleOn 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-04882095B3B6Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=windows-1252Hi Lawrence,
HDD with 8GB =RAM
/Palle
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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug Reporting: support@webdna.us
=--Apple-Mail=_167A6CCE-A494-47AF-89FF-04882095B3B6--
Associated Messages, from the most recent to the oldest:
--Apple-Mail=_167A6CCE-A494-47AF-89FF-04882095B3B6Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=windows-1252Hi Lawrence,HDD with 8GB RAM/PalleOn 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-04882095B3B6Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=windows-1252Hi Lawrence,
HDD with 8GB =RAM
/Palle
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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/l=ist/talk@webdna.usBug 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)