Re: Search crashing server

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17633
interpreted = N
texte = Thanks for the tips, Ken. I'll grab 2.,1.3, assuming I can FTP it from Pacific Coast. Any hints on how in the worId I would write the date to a database as the number of days since 00/00/0000?Kenneth Grome wrote: > > >The following search in one of my templates works fine: > > > >
> >Search the access log by user:       > >
> > > >but this one causes WebSTAR to pause for a moment, and usually crash: > > > >
> >Search the access log by date:       > >
> > > >WebCat plug-in 2.1.1; WebSTAR 3.0 with plenty of RAM allocated. > > Try version 2.1.3, it fixes some problems which occur when malformed dates exist in your database. > > If that doesn't work, I would suggest changing all the dates in your db from formatted dates (such as 05/12/1998) to the number of days since 00/00/0000. That's what I had to do in order to get WebCat to repond relatively quickly to date searches ... > > I received an earlier response from PCS, here on the talk list, stating that when dates are stired in the database as formatted date values (such as 05/12/1998, which is the typical way to do it, of course), WebCat needs to turn each of those formatted date values into a numeric value *before* it can do the date comparison. > > So the larger your database, the more conversions WebCat has to make, and the longer it takes before it can return the results. That's why storing your dates as the number of days since 00/00/0000 results in far faster search times -- because no conversions are necessary when the dates are already stored as numbers ... :) > > Sincerely, > Ken Grome > 808-737-6499 > WebDNA Solutions > mailto:ken@webdna.net > http://www.webdna.net-- 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, 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:

    
  1. Re: Search crashing server (Gil Poulsen 1998)
  2. Re: Search crashing server (Kenneth Grome 1998)
  3. Re: Search crashing server (bob 1998)
  4. Search crashing server (Gil Poulsen 1998)
Thanks for the tips, Ken. I'll grab 2.,1.3, assuming I can FTP it from Pacific Coast. Any hints on how in the worId I would write the date to a database as the number of days since 00/00/0000?Kenneth Grome wrote: > > >The following search in one of my templates works fine: > > > >
> >Search the access log by user:       > >
> > > >but this one causes WebSTAR to pause for a moment, and usually crash: > > > >
> >Search the access log by date:       > >
> > > >WebCat plug-in 2.1.1; WebSTAR 3.0 with plenty of RAM allocated. > > Try version 2.1.3, it fixes some problems which occur when malformed dates exist in your database. > > If that doesn't work, I would suggest changing all the dates in your db from formatted dates (such as 05/12/1998) to the number of days since 00/00/0000. That's what I had to do in order to get WebCat to repond relatively quickly to date searches ... > > I received an earlier response from PCS, here on the Talk List, stating that when dates are stired in the database as formatted date values (such as 05/12/1998, which is the typical way to do it, of course), WebCat needs to turn each of those formatted date values into a numeric value *before* it can do the date comparison. > > So the larger your database, the more conversions WebCat has to make, and the longer it takes before it can return the results. That's why storing your dates as the number of days since 00/00/0000 results in far faster search times -- because no conversions are necessary when the dates are already stored as numbers ... :) > > Sincerely, > Ken Grome > 808-737-6499 > WebDNA Solutions > mailto:ken@webdna.net > http://www.webdna.net-- 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, 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:

Virtual hosting and webcatNT (1997) Reading through the Order File (1999) Help name our technology! (1997) wc 2 pro users - sites, quotes wanted (1997) question: writing files textb in webmerch (1997) 2.0Beta Command Ref (can't find this instruction) (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Nesting WebDNA in JavaScript (2003) [WebDNA] writing pdfs on the fly (Avery labels #5160) (2010) XML - USPS Lookups - UPS Lookups (2003) [OT] 'Email this story to a friend' (2003) Spawn doesn't work as advertised ... (2000) RAM variables (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) and passing to a cart (1997) Listserver problem (1997) [quantity] within formulas (1997) Signal Raised error (1997) WebDNA Solutions ... sorry! (1997) Job Posting (1998)