Re: Database field limit?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16894
interpreted = N
texte = >On 4/3/1998 7:24 PM, PCS Technical Support so noted... > >>>Is there a limit (in either character count or memory used) to the amount >>>of information which can be used in a single database field? I have a >>>case where a lookup returns a sometimes sizable chunk of HTML from a >>>database and there's been problems with the webserver crashing >>>immediately after (I'm using the plug-in, more than enough memory >>>assigned for the database in question). >> >>How sizeable are we talking here? I've seen 300K go out from WebCatalog on >>a single HTML page before. There are no built-in limits to the database, >>so I can only imagine that perhaps W* is freaking at the huge amount of >>data. > >The database itself is 25 meg, but the individual records that are being >looked up and added to the page are only about 4 - 6K each. We're running >WebTen and see odd things in the Access Log after the crash (ie: five or >so lines of the database being searched appear verbatim in the log!) The >problem may be tied into what the page is trying to do. Essentially, if a >certain condition is met, the bulk of the page is hidden and a different >page shown instead (via an Include). Right now I'm working on a different >way of handling the page : )If you're doing comparisions you must probably wrap both the search term and the field you're searching in [URL] contexts, because else, if any of the two contains !><^ or something else WebCat uses for comparions, the search will stop at that character. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Art director S-211 37 Malmoe Fax +46 40 97 99 77 Ljusa Ideer AB Sweden http://www.ljusaideer.se Associated Messages, from the most recent to the oldest:

    
  1. Re: Database field limit? (christer@ljusaideer.se (Christer Olsson) 1998)
  2. RE: Database field limit? (Bob Minor 1998)
  3. Re: Database field limit? (Rob Marquardt 1998)
  4. Re: Database field limit? (PCS Technical Support 1998)
  5. Database field limit? (Rob Marquardt 1998)
  6. RE: Database field limit? (Olin 1998)
>On 4/3/1998 7:24 PM, PCS Technical Support so noted... > >>>Is there a limit (in either character count or memory used) to the amount >>>of information which can be used in a single database field? I have a >>>case where a lookup returns a sometimes sizable chunk of HTML from a >>>database and there's been problems with the webserver crashing >>>immediately after (I'm using the plug-in, more than enough memory >>>assigned for the database in question). >> >>How sizeable are we talking here? I've seen 300K go out from WebCatalog on >>a single HTML page before. There are no built-in limits to the database, >>so I can only imagine that perhaps W* is freaking at the huge amount of >>data. > >The database itself is 25 meg, but the individual records that are being >looked up and added to the page are only about 4 - 6K each. We're running >WebTen and see odd things in the Access Log after the crash (ie: five or >so lines of the database being searched appear verbatim in the log!) The >problem may be tied into what the page is trying to do. Essentially, if a >certain condition is met, the bulk of the page is hidden and a different >page shown instead (via an Include). Right now I'm working on a different >way of handling the page : )If you're doing comparisions you must probably wrap both the search term and the field you're searching in [url] contexts, because else, if any of the two contains !><^ or something else WebCat uses for comparions, the search will stop at that character. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Art director S-211 37 Malmoe Fax +46 40 97 99 77 Ljusa Ideer AB Sweden http://www.ljusaideer.se christer@ljusaideer.se (Christer Olsson)

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:

What do you charge? (1998) Cumulative Shipping charge calculations - your help please. (1997) Fun with Dates - finally resolved but.... (1997) NT Manual (1997) WebCat2 - [format thousands] (1997) search results through frames (2000) Help needed! (1998) frames & carts (1997) watch out for format_to_days on NT (1997) webcat2b12 CGI -- Date comparisons (1997) [include] affect on filepaths for links? (1997) Country & Ship-to address & other fields ? (1997) Searchable list archive (1997) errormessages.db (1997) Cool new site (1996) Authenticate (1997) Emailer Set Up (1997) Search bug. Help (2002) NT or Mac (1998) Search in 2 or more catalogs (1997)