2017

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 andLawrence (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 tothe mailing list talk@w=ebdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: suppo=rt@webdna.us

=

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