Re: Whatcha' wanta have?????

Wait a minute... These are actually great ideas and not full of mindless name calling, prattle about which RDBMS is better or anything to do with disparaging one person or another country or heritage. What has this newsgroup come to? Keep it up - I for one love it. Rob Vorbroker --- Andrew Hamm <ahamm@mail.com> wrote: > Fernando Nunes wrote: > > > > After hitting the problem for the 100nd time I > remember another one: > > > > Limit LOCKS per session. Don't allow a user to > hang all the others... > > Nice. Controllable with an SQL statement, so that > our 4GLs can be set low by > default (ie library initialisation function) but > some big reports can free > their soul... > > If this was to satisfy all people, i could see a few > parameters: > > 1) engine's absolute maximum per user (cannot be > exceeded with an SQL > control statement) A value of zero means no hard > limit beyond LOCKS itself. > > 2) suggested maximum locks per process as the > default offering. Processes > can wind themselves up, but normally, no code would > need changing. A value > of zero means not set. > > this way, some sites can choose an absolute limit, > and also, least amount of > code needs changing to really take advantage of the > feature. > > While we're at it - how's about the ability to set a > LOCK growth factor like > the SHMEM parameters? So we'd have > > LOCKS> LOCKSADD > LOCKSMAX > > ===== Rob Vorbroker Phone: 513/336-8695 Vorbroker Consulting, Inc. Fax: 513/336-6812 www.vorbroker.com robv@vorbroker.com __________________________________ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html sending to informix-list sending to informix-list