Search crashing server

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 17616
interpreted = N
texte = The following search in one of my templates works fine:

Search the access log by user:   [search db=../offshore.db&neuserdata=0&usersort=1][FoundItems][user][/FoundItems][/search]     

but this one causes WebSTAR to pause for a moment, and usually crash:

Search the access log by date:   [search db=offshorelog.db&accdatetype=date&geaccdatedata=03/01/98&deaccdatesort=1&accdatesumm=T&max=150][FoundItems][accdate][/FoundItems][/search]     

WebCat plug-in 2.1.1; WebSTAR 3.0 with plenty of RAM allocated.-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (732) 469-2567 ** 429 St. Giles Court * FAX: (732) 469-5823 ** Somerset, NJ * e-mail: help@altimac.com ** 08873 * WWW: http://www.altimac.com *************************************************************** Associated Messages, from the most recent to the oldest:

Re: Search crashing server (Gil Poulsen 1998) Re: Search crashing server (Kenneth Grome 1998) Re: Search crashing server (bob 1998) Search crashing server (Gil Poulsen 1998)

The following search in one of my templates works fine:

Search the access log by user:   [search db=../offshore.db&neuserdata=0&usersort=1][founditems][user][/FoundItems][/search]     

but this one causes WebSTAR to pause for a moment, and usually crash:

Search the access log by date:   [search db=offshorelog.db&accdatetype=date&geaccdatedata=03/01/98&deaccdatesort=1&accdatesumm=T&max=150][founditems][accdate][/FoundItems][/search]     

WebCat plug-in 2.1.1; WebSTAR 3.0 with plenty of RAM allocated.-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (732) 469-2567 ** 429 St. Giles Court * FAX: (732) 469-5823 ** Somerset, NJ * e-mail: help@altimac.com ** 08873 * WWW: http://www.altimac.com *************************************************************** Gil Poulsen

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:

Nested search index (2000) Help name our technology! (1997) NYC-based WebDNA programmers (2003) [format xs] freeze (1997) PIXO Support (1997) Duplicate Cart #'s (1998) Search returns all, not 20 (1997) Search design (1997) Here we go again... was: DDEConnect not working (2006) Webcatalog, Webstar and Crasharama (1999) Ecommerce and downloads (2001) Email Attachments (1998) Authorize.net questions ... (2003) Searchable list archive (1997) Double Spacing in Mails from Sendmail (2002) Help! WebCat2 bug (1997) Emailer (1997) Fun with dates (1997) RE: Formulas.db + Users.db (1997) WebCat2 several catalogs? (1997)