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 PacificCoast. Any hints on how in the worId I would write the date to a database asthe number of days since 00/00/0000?Kenneth Grome wrote:> > >The following search in one of my templates works fine:> >> >
> >> >but this one causes WebSTAR to pause for a moment, and usually crash:> >> >
> >> >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:
Thanks for the tips, Ken. I'll grab 2.,1.3, assuming I can FTP it from PacificCoast. Any hints on how in the worId I would write the date to a database asthe number of days since 00/00/0000?Kenneth Grome wrote:> > >The following search in one of my templates works fine:> >> >
> >> >but this one causes WebSTAR to pause for a moment, and usually crash:> >> >
> >> >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)