RE: Limits for procedures in IDS 7.31

I recall a company I did some work for having their entire application in stored procedured - just over 2000 from what I recall. No problem. You would need to tune your Instance accordingly - cache for stored procedures. The procedures are in a table, so cannot see there being an issue with 10000. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of LE-KIM Valerie - NTR Sent: Monday, October 23, 2000 10:50 PM To: Mailing list Informix (E-mail) Subject: Limits for procedures in IDS 7.31 Hello, I am working on a project (NT4.0 SP4 and IDS 7.31 Workgroup Edition) and I'd like that the developers do not put their SQL requests in the code but directly in the database through stored procedures and/or triggers. The number of needed procedures is estimated at about 10.000. Has anybody any experience about such a great number of procedures ? Can IDS correctly support this number ? Best regards, Val'rie LE KIM Sema Group Tour Horizon 64, rue du 8 Mai 1945 92000 Nanterre France --------------------------- valerie.le-kim@sema.fr ----------------------------------