Re: [WebDNA] Error 500 with SUMM=T

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113833
interpreted = N
texte = 1428 --Apple-Mail=_D8EB82C1-2893-47AD-8256-7B914A253FD1 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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: >=20 > Thanks for this test Brian, > I tested it with your code and everything works fine. > http://www.tourismethaifr.com/admin/testdb.tpl = >=20 > 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 = [/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] >=20 > Maybe somthing to do with RAM... Server... > I have rebooted it! > The db is 3mb, it shouldn't be an issuu... >=20 > It was already running on the same server...=20 >=20 >=20 > 2017-12-12 18:01 GMT+01:00 Brian Fries >: > Here is a test that should determine whether it is a database content = problem: >=20 >=20 > [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] [numfound] = raw[/search]
> [search db=3Dtest.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] = [numfound] summarized[/search] >=20 >=20 > 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 =E2=80=9D= , where the numeric portion is a random integer from zero to 9999, so = there will be duplicates. >=20 > 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. >=20 > 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. >=20 > - Brian Fries >=20 >=20 >> On Dec 12, 2017, at 7:28 AM, Brian Harrington > wrote: >>=20 >> 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! >>=20 >> So we all need to take notes...? >>=20 >>=20 >>=20 >> 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) >>=20 >> I already corrected this typo in a later post ... :) >>=20 >>=20 >> > simple sort example: >> > &*as*emailsort=3D1 >> > (should be &emailsort=3D1) >>=20 >> No it should not! >>=20 >> 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. >>=20 >> Regards, >> Kenneth Grome >> WebDNA Solutions >> http://www.webdnasolutions.com >> Web Database Systems and Linux Server Administration >>=20 >>=20 >> --------------------------------------------------------- >> 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 >>=20 >> --------------------------------------------------------- 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 --Apple-Mail=_D8EB82C1-2893-47AD-8256-7B914A253FD1 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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 = <banahan.l@gmail.com> 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]floor([random = format=3Dfloat]*110000)[/math]@example.com[/append][/loop]
[search = db=3Dtest.db&ne_emaildata=3DFIND_ALL] [numfound] = raw[/search]<br>
[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 <iphonzie@gmail.com>:
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[/append][/loop]
[search = db=3Dtest.db&ne_emaildata=3DFIND_ALL] [numfound] = raw[/search]<br>
[search = db=3Dtest.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3D= T] [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=E2=80=9D, where the numeric portion = is 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 <autoglasswny@gmail.com> 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 <ken@webdnasolutions.com> = 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.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 --Apple-Mail=_D8EB82C1-2893-47AD-8256-7B914A253FD1-- . 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)
1428 --Apple-Mail=_D8EB82C1-2893-47AD-8256-7B914A253FD1 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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: >=20 > Thanks for this test Brian, > I tested it with your code and everything works fine. > http://www.tourismethaifr.com/admin/testdb.tpl = >=20 > 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 = [/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] >=20 > Maybe somthing to do with RAM... Server... > I have rebooted it! > The db is 3mb, it shouldn't be an issuu... >=20 > It was already running on the same server...=20 >=20 >=20 > 2017-12-12 18:01 GMT+01:00 Brian Fries >: > Here is a test that should determine whether it is a database content = problem: >=20 >=20 > [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] [numfound] = raw[/search]
> [search db=3Dtest.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3DT] = [numfound] summarized[/search] >=20 >=20 > 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 =E2=80=9D= , where the numeric portion is a random integer from zero to 9999, so = there will be duplicates. >=20 > 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. >=20 > 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. >=20 > - Brian Fries >=20 >=20 >> On Dec 12, 2017, at 7:28 AM, Brian Harrington > wrote: >>=20 >> 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! >>=20 >> So we all need to take notes...? >>=20 >>=20 >>=20 >> 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) >>=20 >> I already corrected this typo in a later post ... :) >>=20 >>=20 >> > simple sort example: >> > &*as*emailsort=3D1 >> > (should be &emailsort=3D1) >>=20 >> No it should not! >>=20 >> 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. >>=20 >> Regards, >> Kenneth Grome >> WebDNA Solutions >> http://www.webdnasolutions.com >> Web Database Systems and Linux Server Administration >>=20 >>=20 >> --------------------------------------------------------- >> 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 >>=20 >> --------------------------------------------------------- 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 --Apple-Mail=_D8EB82C1-2893-47AD-8256-7B914A253FD1 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
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 = <banahan.l@gmail.com> 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]floor([random = format=3Dfloat]*110000)[/math]@example.com[/append][/loop]
[search = db=3Dtest.db&ne_emaildata=3DFIND_ALL] [numfound] = raw[/search]<br>
[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 <iphonzie@gmail.com>:
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[/append][/loop]
[search = db=3Dtest.db&ne_emaildata=3DFIND_ALL] [numfound] = raw[/search]<br>
[search = db=3Dtest.db&ne_emaildata=3DFIND_ALL&_emailSUMM=3D= T] [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=E2=80=9D, where the numeric portion = is 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 <autoglasswny@gmail.com> 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 <ken@webdnasolutions.com> = 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.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 --Apple-Mail=_D8EB82C1-2893-47AD-8256-7B914A253FD1-- . Brian Fries

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:

Suffix Mapping????? (1998) Date sorting (1997) WebCommerce: Folder organization ? (1997) WebCat2b15MacPlugin - showing [math] (1997) Single Link browsing (1997) Cancel Subscription (1996) problems with 2 tags (1997) [WebDNA] Dreamweaver Tag Libraries and Snippets (2010) Running _every_ page through WebCat ? (1997) Mac 2.1b4 unknown error: BadSuffix (1997) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Multiple cart additions (1997) web delivery (1997) Help with Repost Data msg from form (1997) Another bug to squash (WebCat2b13 Mac .acgi) (1997) [WebDNA] WebDNA future (2010) Fwd: Problems with Webcatalog Plug-in (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) What file? (1997) [convertChars] and in a textarea on a form (1998)