LMAO... maybe that's why the cable company makes u reb= oot first thing! my current server 2006 mac pro 32BG 2X 3GHZ dual cores =C2= =A00 raid on 4 X2TB HDD's...=C2=A0
=C2=A0trying to s= peed load times on my heavy dynamic site=C2=A0
classifieds.today= =C2=A0that does not "mirror" but takes on any domain like it'= s own like
http://scottsclassifie= ds.com/ or the 20 other current domains have pointing that way.... boug= ht an upgraded 12 core 2.66 w/64 GB ram and turned out not much better and = was actually slower to serve my less complicated sites! I thought maybe it = was the builder so picked up 12 core 3.46! 128GB ram and 1TB SSD and 8TB 0 = RAID and same slow results! HUH=C2=A0=C2=A0(Both R for sale anyone interest= ed)
Don't get this 6GB's they claim. When = they go on to tell you best read/writes are 500/mb's...???!!!=C2=A0
=C2=A0 =C2=A0The so claimed PCIe SSD is now used to drop files (back= ups) on and I really don't see it any faster than the IDE I put in my C= D slot! Takes 10 seconds either one on a drag-n-drop! LOL
Glad you have it fixed... now we can all rest! LOL
--------------------------------------------------------- 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://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --089e082d74bcf21a9b05602d71ef-- .
Associated Messages, from the most recent to the oldest:
1440 --089e082d74bcf21a9b05602d71ef Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable LMAO... maybe that's why the cable company makes u reboot first thing! my current server 2006 mac pro 32BG 2X 3GHZ dual cores 0 raid on 4 X2TB HDD's... trying to speed load times on my heavy dynamic site classifieds.today that does not "mirror" but takes on any domain like it's own like http://scottsclassifieds.com/ or the 20 other current domains have pointing that way.... bought an upgraded 12 core 2.66 w/64 GB ram and turned out not much better and was actually slower to serve my less complicated sites! I thought maybe it was the builder so picked up 12 core 3.46! 128GB ram and 1TB SSD and 8TB 0 RAID and same slow results! HUH (Both R for sale anyone interested) Don't get this 6GB's they claim. When they go on to tell you best read/writes are 500/mb's...???!!! The so claimed PCIe SSD is now used to drop files (backups) on and I really don't see it any faster than the IDE I put in my CD slot! Takes 10 seconds either one on a drag-n-drop! LOL Glad you have it fixed... now we can all rest! LOL On Tue, Dec 12, 2017 at 6:05 PM,
wrote: > Sorry, I probably missed this in all the emails, but did you state your > server info? > > WebDNA Version > Operating System > > Can you post the results of 'free' and 'df -h' from the commandline? > > Donovan > > > > On 2017-12-12 12:02, Lawrence Banahan wrote: > >> I have "only" 16 Gb Ram, I also had that with V6, so it looks like >> V8.5 needs more Ram... >> >> 2017-12-12 18:41 GMT+01:00 Brian Fries : >> >> I ran with your numbers and it worked fine for me. I bumped them up >>> to 535000 and 510000, and I got the =E2=80=9C500 Internal Server Error= =E2=80=9D >>> >>> So, it looks like an available RAM issue, as you said, with my limit >>> higher than yours due to different system configuration. >>> >>> - Brian Fries >>> >>> On Dec 12, 2017, at 9:26 AM, Lawrence Banahan >>> [18]> wrote: >>>> >>>> Thanks for this test Brian, >>>> I tested it with your code and everything works fine. >>>> http://www.tourismethaifr.com/admin/testdb.tpl [19] >>>> >>>> I have tested with the same amount of data 135 000 like in my DB >>>> and then it crash... >>>> http://www.tourismethaifr.com/admin/testdb2.tpl [20] >>>> >>>> [closedatabase test.db] >>>> [writefile test.db]_email >>>> [/writefile] >>>> [loop start=3D1&end=3D135000][append >>>> db=3Dtest.db]_email=3Dtest[math]floor([random >>>> format=3Dfloat]*110000)[/math]@example.com [21][/append][/loop] >>>> [search db=3Dtest.db&ne_emaildata=3DFIND_ALL] [numfound] >>>> raw[/search]
>>>> [search db=3Dtest.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] [numfound= ] >>>> summarized[/search] >>>> >>>> Maybe somthing to do with RAM... Server... >>>> I have rebooted it! >>>> The db is 3mb, it shouldnt be an issuu... >>>> >>>> It was already running on the same server... >>>> >>>> 2017-12-12 18:01 GMT+01:00 Brian Fries : >>>> >>>> Here is a test that should determine whether it is a database >>>>> content problem: >>>>> >>>>> [closedatabase test.db] >>>>> [writefile test.db]_email >>>>> [/writefile] >>>>> [loop start=3D1&end=3D15000][append >>>>> db=3Dtest.db]_email=3Dtest[math]floor([random >>>>> format=3Dfloat]*10000)[/math]@example.com [12][/append][/loop] >>>>> [search db=3Dtest.db&ne_emaildata=3DFIND_ALL] [numfound] >>>>> raw[/search]
>>>>> [search db=3Dtest.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] >>>>> [numfound] summarized[/search] >>>>> >>>>> This will create a database named =E2=80=9Ctest.db=E2=80=9D with one = field - >>>>> =E2=80=9C_email=E2=80=9D, then add 15000 records with _email set to a= value >>>>> like "test6746@example.com [13]=E2=80=9D, where the numeric portion i= s >>>>> a random integer from zero to 9999, so there will be duplicates. >>>>> >>>>> In my test on a linux server running WebDNA 8.5.1, it works >>>>> fine, with the raw results returning 15000 records, and the >>>>> summarized results varying from one run to the next, usually >>>>> around 7800 unique values. >>>>> >>>>> My guess would be that this will work fine for you as well, and >>>>> that there is some data in the real database that WebDNA is >>>>> choking on when running the SUMM comparisons. I this is the >>>>> case, then the next step would be to split the real data into >>>>> smaller subsets and run the test on those until you can isolate >>>>> what data is causing WebDNA problems. Then Chris will have >>>>> something specific to fix. >>>>> >>>>> - Brian Fries >>>>> >>>>> On Dec 12, 2017, at 7:28 AM, Brian Harrington >>>>>> wrote: >>>>>> >>>>>> exactly what Ive been saying... you all keep your little code >>>>>> a secret and NO resource on the website, same site for 12 >>>>>> years! yelp... just checked "search" on "sort" NO REF THERE! >>>>>> >>>>>> So we all need to take notes...? >>>>>> >>>>>> On Tue, Dec 12, 2017 at 12:04 PM, Kenneth Grome >>>>>> wrote: >>>>>> >>>>>> I see two problems with >>>>>>>> >>>>>>> > >>>>>>> > complex sort example: >>>>>>> > &email*S*sort=3D1&emailsdir=3Das >>>>>>> > (should be &emailsort=3D1&emailsdir=3Das) >>>>>>> >>>>>>> I already corrected this typo in a later post ... :) >>>>>>> >>>>>>> > simple sort example: >>>>>>> > &*as*emailsort=3D1 >>>>>>> > (should be &emailsort=3D1) >>>>>>> >>>>>>> No it should not! >>>>>>> >>>>>>> Youre saying this because you do not know how to write >>>>>>> simpler >>>>>>> sort code. And thats why I posted this example ... so you >>>>>>> and >>>>>>> Lawrence (and anyone else who does not know this) might >>>>>>> learn how >>>>>>> to do it. >>>>>>> >>>>>>> Regards, >>>>>>> Kenneth Grome >>>>>>> WebDNA Solutions >>>>>>> http://www.webdnasolutions.com [1] >>>>>>> Web Database Systems and Linux Server Administration >>>>>>> >>>>>>> --------------------------------------------------------- >>>>>>> This message is sent to you because you are subscribed to >>>>>>> the mailing list talk@webdna.us [2] >>>>>>> To unsubscribe, E-mail to: talk-leave@webdna.us [3] >>>>>>> archives: http://www.webdna.us/page.dna?numero=3D55 [4] >>>>>>> Bug Reporting: support@webdna.us [5] >>>>>>> >>>>>> >>>>>> --------------------------------------------------------- >>>>>> This message is sent to you because you are subscribed to the >>>>>> mailing list talk@webdna.us [8] To unsubscribe, E-mail to: >>>>>> talk-leave@webdna.us [9] archives: >>>>>> http://www.webdna.us/page.dna?numero=3D55 [10] Bug Reporting: >>>>>> support@webdna.us [11] >>>>>> >>>>> >>>>> --------------------------------------------------------- This >>>>> message is sent to you because you are subscribed to the mailing >>>>> list talk@webdna.us [14] To unsubscribe, E-mail to: >>>>> talk-leave@webdna.us [15] archives: >>>>> http://www.webdna.us/page.dna?numero=3D55 [16] Bug Reporting: >>>>> support@webdna.us [17] >>>>> >>>> >>>> --------------------------------------------------------- This >>>> message is sent to you because you are subscribed to the mailing >>>> list talk@webdna.us [23] To unsubscribe, E-mail to: >>>> talk-leave@webdna.us [24] archives: >>>> http://www.webdna.us/page.dna?numero=3D55 [25] Bug Reporting: >>>> support@webdna.us [26] >>>> >>> >>> --------------------------------------------------------- This >>> message is sent to you because you are subscribed to the mailing >>> list talk@webdna.us [27] To unsubscribe, E-mail to: >>> talk-leave@webdna.us [28] archives: >>> http://www.webdna.us/page.dna?numero=3D55 [29] Bug Reporting: >>> support@webdna.us [30] >>> >> >> --------------------------------------------------------- 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://www.webdna.us/page.dna?numero=3D55 Bug Reporting: >> support@webdna.us >> >> Links: >> ------ >> [1] http://www.webdnasolutions.com/ >> [2] mailto:talk@webdna.us >> [3] mailto:talk-leave@webdna.us >> [4] http://www.webdna.us/page.dna?numero=3D55 >> [5] mailto:support@webdna.us >> [6] mailto:autoglasswny@gmail.com >> [7] mailto:ken@webdnasolutions.com >> [8] mailto:talk@webdna.us >> [9] mailto:talk-leave@webdna.us >> [10] http://www.webdna.us/page.dna?numero=3D55 >> [11] mailto:support@webdna.us >> [12] http://example.com/ >> [13] mailto:test6746@example.com >> [14] mailto:talk@webdna.us >> [15] mailto:talk-leave@webdna.us >> [16] http://www.webdna.us/page.dna?numero=3D55 >> [17] mailto:support@webdna.us >> [18] mailto:banahan.l@gmail.com >> [19] http://www.tourismethaifr.com/admin/testdb.tpl >> [20] http://www.tourismethaifr.com/admin/testdb2.tpl >> [21] http://example.com/ >> [22] mailto:iphonzie@gmail.com >> [23] mailto:talk@webdna.us >> [24] mailto:talk-leave@webdna.us >> [25] http://www.webdna.us/page.dna?numero=3D55 >> [26] mailto:support@webdna.us >> [27] mailto:talk@webdna.us >> [28] mailto:talk-leave@webdna.us >> [29] http://www.webdna.us/page.dna?numero=3D55 >> [30] mailto:support@webdna.us >> [31] mailto:iphonzie@gmail.com >> > > --------------------------------------------------------- > 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://www.webdna.us/page.dna?numero=3D55 > Bug Reporting: support@webdna.us > --089e082d74bcf21a9b05602d71ef Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable LMAO... maybe that's why the cable company makes u reb= oot first thing! my current server 2006 mac pro 32BG 2X 3GHZ dual cores =C2= =A00 raid on 4 X2TB HDD's...=C2=A0
=C2=A0trying to s= peed load times on my heavy dynamic site=C2=A0
classifieds.today= =C2=A0that does not "mirror" but takes on any domain like it'= s own like
http://scottsclassifie= ds.com/ or the 20 other current domains have pointing that way.... boug= ht an upgraded 12 core 2.66 w/64 GB ram and turned out not much better and = was actually slower to serve my less complicated sites! I thought maybe it = was the builder so picked up 12 core 3.46! 128GB ram and 1TB SSD and 8TB 0 = RAID and same slow results! HUH=C2=A0=C2=A0(Both R for sale anyone interest= ed)