Re: Search crashing server
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17622
interpreted = N
texte = >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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Kenneth Grome
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:
cart (1997)
[WebDNA] try/except (2015)
RE: OK, here goes... (1997)
question on max variable in searching... (2000)
WC2b15 File Corruption (1997)
Yet another db manager (2004)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Sku numbers (1997)
b12 cannot limit records returned and more. (1997)
Re1000002: Setting up shop (1997)
Applescript, WebDNA, and PDF (1997)
More Applescript (1997)
A Global Variable (1997)
Multiple serial numbers (1997)
can WC render sites out? (1997)
PDF on the fly - how to? (2005)
WebCatalog2 Feature Feedback (1996)
I'm having trouble using [url][interpret][math] together in lookup (1997)
Shopping Cart Limits? (1998)
[Webcat 2]Next (1997)