Re: Was cart limit-- Limits

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 44029
interpreted = N
texte = Is there a limit of 100 db's open at once per server? I've only been using Webcat (WebDNA) since '99, but I don't ever recall hearing of this limitation.Kalin's issue was 100 items per shoppingcart, which I was well aware of.Speaking of limitations or restrictions, has anybody had any issues or disappointments or satisfactions even with the new concurrent users restrictions of the lighter versions of 4.5?GK> on 10/9/02 6:47 PM, Gary Krockover at gary@garykrockover.com wrote: > > > In all seriousness: > There is one limit that we are commonly dealing with that is of concern to > us and that is the 100 simultaneous db limit. It used to be that none of us > could imagine why more than 100 would be needed. And then there was the > issue of ram. And then performance of having 100+ files open. > > Now we see screaming machines, 2G of ram, performance to die for, all the > while more and more complicated relational tables being established and the > limit stays the same. Couple this with multiple client sites on the same > machine and the limits hit you fast. hell some stores have 20+dbs for each > store. > > I can guarantee that out server has 100 db(s) open at this very minute and i > am currently working on 2 projects that would introduce another 35 dbs. > > I would love to know when the limit will go away, and if not, what the logic > is. Honestly, i can see no valid reason why a super fast g4 with 2g of ram > should be constrained to 100 dbs! > > Frankly this limit and the inability to load balance are steadily becoming > our primary concerns and both will likely force us into unwanted territory > if they cant change. > > Just sharing. > > > Tongue in cheek: > > > > http://www.yourserver.com/ShoppingCart.tpl?command=ShowCart&cart=[cart]&db=[ > > db] > > > > > > Goes to ShoppingCart.tpl with: > > [showif [NumLineItems]>99] > > Check out already, for Christ's sake! > > [/showif] > > [showif [NumLineItems]<99] > > Come on, fill up that cart!
> > Here:
> > index.html?cart=[cart] > > [/showif] > > -- > > Alex J McCombie New World Media > >> Chief Information Officer Drawer 607 > > 800/724.8973 Fair Haven, NY 13064 > >> Alex@NewWorldMedia.com http://OurClients.com > > > Interface Designer WebDNA Programmer Database Designer ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Was cart limit-- Limits (Kenneth Grome 2002)
  2. Re: Was cart limit-- Limits (Kenneth Grome 2002)
  3. Re: Was cart limit-- Limits (Bob Minor 2002)
  4. Re: Was cart limit-- Limits (Andrew Simpson 2002)
  5. Re: Was cart limit-- Limits (Stuart Tremain 2002)
  6. Re: Was cart limit-- Limits (Alex McCombie 2002)
  7. Re: Was cart limit-- Limits (Gary Krockover 2002)
Is there a limit of 100 db's open at once per server? I've only been using Webcat (WebDNA) since '99, but I don't ever recall hearing of this limitation.Kalin's issue was 100 items per shoppingcart, which I was well aware of.Speaking of limitations or restrictions, has anybody had any issues or disappointments or satisfactions even with the new concurrent users restrictions of the lighter versions of 4.5?GK> on 10/9/02 6:47 PM, Gary Krockover at gary@garykrockover.com wrote: > > > In all seriousness: > There is one limit that we are commonly dealing with that is of concern to > us and that is the 100 simultaneous db limit. It used to be that none of us > could imagine why more than 100 would be needed. And then there was the > issue of ram. And then performance of having 100+ files open. > > Now we see screaming machines, 2G of ram, performance to die for, all the > while more and more complicated relational tables being established and the > limit stays the same. Couple this with multiple client sites on the same > machine and the limits hit you fast. hell some stores have 20+dbs for each > store. > > I can guarantee that out server has 100 db(s) open at this very minute and i > am currently working on 2 projects that would introduce another 35 dbs. > > I would love to know when the limit will go away, and if not, what the logic > is. Honestly, i can see no valid reason why a super fast g4 with 2g of ram > should be constrained to 100 dbs! > > Frankly this limit and the inability to load balance are steadily becoming > our primary concerns and both will likely force us into unwanted territory > if they cant change. > > Just sharing. > > > Tongue in cheek: > > > > http://www.yourserver.com/ShoppingCart.tpl?command=ShowCart&cart=[cart]&db=[ > > db] > > > > > > Goes to ShoppingCart.tpl with: > > [showif [NumLineItems]>99] > > Check out already, for Christ's sake! > > [/showif] > > [showif [NumLineItems]<99] > > Come on, fill up that cart!
> > Here:
> > index.html?cart=[cart] > > [/showif] > > -- > > Alex J McCombie New World Media > >> Chief Information Officer Drawer 607 > > 800/724.8973 Fair Haven, NY 13064 > >> Alex@NewWorldMedia.com http://OurClients.com > > > Interface Designer WebDNA Programmer Database Designer ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Gary Krockover

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:

New Site Announcement (1998) Need relative path explanation (1997) RE: Tax and ShipCost Problem (1997) 5.0 Preview Promotion Extension (2003) Protect vs Authenicate (1997) [convertchars] problem... (2000) how to construct a search for not this entire string? (2000) WebCatalog for guestbook ? (1997) [include ...] behavior (1997) Add to Cart & List of Products (1997) [WebDNA] drop off not round off (2011) Size limit for tmpl editor ? (1997) Help name our technology! I found it (1997) Ecommerce client for someone (2006) [math date] with non-US date format (2000) Allow-Deny: Solved with [Getchars] (1998) Round up prices (2000) handling cookies in and out of secure space (2000) Bug? (1997) Installer AppleScript (2000)