What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

[Shownext] [whynot] (2000) Editor Recommendation for NT Users (1998) [SearchString] problem with [search] context (1997) FYI: virus alert (1996) Wanted: More Math Functions (or, Can You Solve This?) (1997) Speed Optimization - Mac (1997) Exists? (1997) So when do we get something similar? (1998) Have no fear of WebCatalog Builder..... (2000) Nested tags count question (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WebCat for Unix?? (1997) database files in secure folder (1997) RE: WebDNA-Talk searchable? (1997) File Upload (1997) ShoppingCart removal (2002) MacActivity and PCS (1997) Multiple fields on 1 input (1997) WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997) WebCat2 several catalogs? (1997)