Re: [WebDNA] Error 500 with SUMM=T

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113834
interpreted = N
texte = 1429 --94eb2c0930623a0467056028761e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 wrote= : > > Thanks for this test Brian, > I tested it with your code and everything works fine. > http://www.tourismethaifr.com/admin/testdb.tpl > > 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 > > [closedatabase test.db] > [writefile test.db]_email > [/writefile] > [loop start=3D1&end=3D135000][append db=3Dtest.db]_email=3Dtest[math]floo= r([random > format=3Dfloat]*110000)[/math]@example.com[/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 shouldn't 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]floo= r([random >> format=3Dfloat]*10000)[/math]@example.com[/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 fie= ld - =E2=80=9C_email=E2=80=9D, >> then add 15000 records with _email set to a value like " >> test6746@example.com=E2=80=9D, where the numeric portion is a random int= eger >> 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 vary= ing >> 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 wou= ld >> 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 w= ill >> have something specific to fix. >> >> - Brian Fries >> >> >> On Dec 12, 2017, at 7:28 AM, Brian Harrington >> wrote: >> >> exactly what I've 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! >>> >>> You're saying this because you do not know how to write simpler >>> sort code. And that's 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 >>> Web Database Systems and Linux Server Administration >>> >>> >>> --------------------------------------------------------- >>> 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 >>> >> >> --------------------------------------------------------- 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 >> >> >> --------------------------------------------------------- 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 >> > > --------------------------------------------------------- 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.u= s > > > --------------------------------------------------------- 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.u= s > --94eb2c0930623a0467056028761e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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 <iphonzie@gmail.com>:
I ran with your numbers and it worked f= ine for me. I bumped them up to 535000 and 510000, and I got the =E2=80=9C5= 00 Internal Server Error=E2=80=9D

So, it looks lik= e 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 <banahan.l@gmail.com> wrote:

<= div>
Thanks for this test Brian,
I tested it with your code an= d everything works fine.
http://www.tourismethaifr.com/admin/test= db.tpl

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

[closedatabase test.db]
= [writefile test.db]_email
[/writefile]
[loop start=3D1&end=3D1350= 00][append db=3Dtest.db]_email=3Dtest[math]floor([random format=3Dfloa= t]*110000)[/math]@ex= ample.com[/append][/loop]
[search db=3Dtest.db&ne_emaildata=3DFI= ND_ALL] [numfound] raw[/search]<br>
[search db=3Dtest.db&= ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] [numfound] summarized[/sea= rch]

Maybe somthing to do with RAM... Server...
=
I have rebooted it!
The db is 3mb, it shouldn't be an is= suu...

It was already running on the same server...
<= div>

=
2017-12-12 18:01 GMT+01:00 Brian Fries <ip= honzie@gmail.com>:
Here is a test that should determine wheth= er 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[/append]= [/loop]
[search db=3Dtest.db&ne_emaildata=3DFIND_ALL] [n= umfound] raw[/search]<br>
[search db=3Dtest.db&ne_email= data=3DFIND_ALL&_emailSUMM=3DT] [numfound] summarized[/search]


This will create a database name= d =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=E2=80=9D, = where the numeric portion is a random integer from zero to 9999, so there w= ill be duplicates.

In my test on a linux server ru= nning WebDNA 8.5.1, it works fine, with the raw results returning 15000 rec= ords, 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 rea= l database that WebDNA is choking on when running the SUMM comparisons. I t= his is the case, then the next step would be to split the real data into sm= aller 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, 2= 017, at 7:28 AM, Brian Harrington <autoglasswny@gmail.com> wrote:

<= div>
exactly what I've been saying... you all keep your= little code a secret and NO resource on the website, =C2=A0same site for 1= 2 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 <ken@we= bdnasolutions.com> wrote:
<= span>> 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!

You're saying this because you do not know how to write simpler
sort code.=C2=A0 And that's 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
Web Database Systems and Linux Server Administration


---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list talk@w= ebdna.us
To unsubscribe, E-mail to: talk-leave@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
Bug Reporting:
suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

=
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- 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 --94eb2c0930623a0467056028761e-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  2. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  3. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  4. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  5. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  6. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  7. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  8. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  9. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  10. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  11. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  12. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  13. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  14. Re: [WebDNA] Error 500 with SUMM=T (Christer Olsson 2017)
  15. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  16. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  17. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  18. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  19. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  20. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  21. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  22. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  23. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  24. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  25. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  26. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  27. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  28. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  29. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  30. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  31. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  32. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  33. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  34. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  35. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  36. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  37. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  38. [BULK] Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  39. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  40. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  41. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  42. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  43. Re: [WebDNA] Error 500 with SUMM=T ("Lawrence Banahan - Author's Image" 2017)
  44. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  45. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  46. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  47. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  48. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  49. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  50. Re: [WebDNA] Error 500 with SUMM=T (Kenneth Grome 2017)
  51. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  52. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  53. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  54. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  55. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  56. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  57. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  58. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  59. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  60. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  61. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  62. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  63. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  64. Re: [WebDNA] Error 500 with SUMM=T (Brian Harrington 2017)
  65. Re: [WebDNA] Error 500 with SUMM=T (christophe.billiottet@webdna.us 2017)
  66. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  67. Re: [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
  68. Re: [WebDNA] Error 500 with SUMM=T (Brian Fries 2017)
  69. Re: [WebDNA] Error 500 with SUMM=T (Stuart Tremain 2017)
  70. [WebDNA] Error 500 with SUMM=T (Lawrence Banahan 2017)
1429 --94eb2c0930623a0467056028761e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 wrote= : > > Thanks for this test Brian, > I tested it with your code and everything works fine. > http://www.tourismethaifr.com/admin/testdb.tpl > > 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 > > [closedatabase test.db] > [writefile test.db]_email > [/writefile] > [loop start=3D1&end=3D135000][append db=3Dtest.db]_email=3Dtest[math]floo= r([random > format=3Dfloat]*110000)[/math]@example.com[/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 shouldn't 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]floo= r([random >> format=3Dfloat]*10000)[/math]@example.com[/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 fie= ld - =E2=80=9C_email=E2=80=9D, >> then add 15000 records with _email set to a value like " >> test6746@example.com=E2=80=9D, where the numeric portion is a random int= eger >> 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 vary= ing >> 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 wou= ld >> 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 w= ill >> have something specific to fix. >> >> - Brian Fries >> >> >> On Dec 12, 2017, at 7:28 AM, Brian Harrington >> wrote: >> >> exactly what I've 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! >>> >>> You're saying this because you do not know how to write simpler >>> sort code. And that's 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 >>> Web Database Systems and Linux Server Administration >>> >>> >>> --------------------------------------------------------- >>> 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 >>> >> >> --------------------------------------------------------- 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 >> >> >> --------------------------------------------------------- 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 >> > > --------------------------------------------------------- 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.u= s > > > --------------------------------------------------------- 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.u= s > --94eb2c0930623a0467056028761e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
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 <iphonzie@gmail.com>:
I ran with your numbers and it worked f= ine for me. I bumped them up to 535000 and 510000, and I got the =E2=80=9C5= 00 Internal Server Error=E2=80=9D

So, it looks lik= e 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 <banahan.l@gmail.com> wrote:

<= div>
Thanks for this test Brian,
I tested it with your code an= d everything works fine.
http://www.tourismethaifr.com/admin/test= db.tpl

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

[closedatabase test.db]
= [writefile test.db]_email
[/writefile]
[loop start=3D1&end=3D1350= 00][append db=3Dtest.db]_email=3Dtest[math]floor([random format=3Dfloa= t]*110000)[/math]@ex= ample.com[/append][/loop]
[search db=3Dtest.db&ne_emaildata=3DFI= ND_ALL] [numfound] raw[/search]<br>
[search db=3Dtest.db&= ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] [numfound] summarized[/sea= rch]

Maybe somthing to do with RAM... Server...
=
I have rebooted it!
The db is 3mb, it shouldn't be an is= suu...

It was already running on the same server...
<= div>

=
2017-12-12 18:01 GMT+01:00 Brian Fries <ip= honzie@gmail.com>:
Here is a test that should determine wheth= er 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[/append]= [/loop]
[search db=3Dtest.db&ne_emaildata=3DFIND_ALL] [n= umfound] raw[/search]<br>
[search db=3Dtest.db&ne_email= data=3DFIND_ALL&_emailSUMM=3DT] [numfound] summarized[/search]


This will create a database name= d =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=E2=80=9D, = where the numeric portion is a random integer from zero to 9999, so there w= ill be duplicates.

In my test on a linux server ru= nning WebDNA 8.5.1, it works fine, with the raw results returning 15000 rec= ords, 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 rea= l database that WebDNA is choking on when running the SUMM comparisons. I t= his is the case, then the next step would be to split the real data into sm= aller 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, 2= 017, at 7:28 AM, Brian Harrington <autoglasswny@gmail.com> wrote:

<= div>
exactly what I've been saying... you all keep your= little code a secret and NO resource on the website, =C2=A0same site for 1= 2 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 <ken@we= bdnasolutions.com> wrote:
<= span>> 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!

You're saying this because you do not know how to write simpler
sort code.=C2=A0 And that's 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
Web Database Systems and Linux Server Administration


---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list talk@w= ebdna.us
To unsubscribe, E-mail to: talk-leave@webdna.us
archives: http://www.webdna.us/page.dna?numero=3D55
Bug Reporting:
suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

=
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- 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 --94eb2c0930623a0467056028761e-- . 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:

still having shipCost.db Problem (1997) [index] (1997) Database not found in Include (2002) Displaying photo attached to first record (1997) Re:Hideif / Showif (1998) Forms Search Questions (1997) Emailer to include Human Name with email Address (2000) Quit revisited (1997) bug in listwords? (1998) Calendar using WebCatalog? (1997) TcpConnect get files on ver. 5.x FIXED FIXED FIXED - (2004) [WebDNA] Simple Date Format Conversion (2008) OT: Need some feedback, please. (2003) Search returns all, not 20 (1997) WebCat2b12--[searchstring] bug (1997) auto enter dates (1998) Fwd: [WebDNA] Fails to recognize comma-separated db (2010) WebCatalog2 Feature Feedback (1996) Country & Ship-to address & other fields ? (1997) WebDNA 5.0 Questions (2003)