Re: 4gl -> spl

In <1993May24.202719.17182@informix.com> davek@informix.com (David Kosenko) writes: >Dave Cortesi writes: >>Cathy Kipp writes: >> >>> While the concept is nice, I was given the impression that they added to >>> the size of the engine and should therefore be used sparingly. >> >>The engine is increased by the size of the SPL interpreter, but that's a >>done deal. >Yes, but it is also increased by the memory allocated in each server process >to hold the SPL "p-code". Thus Cathy is correct in that the more you use, >the more memory will be required for each sqlturbo/sqlexec (up to the 16 >procedures that are cached) But what Cathy seems to be ignoring is that there should be a reduction in memory required by the application, because the logic has been moved to the server. Who is brave enough to attempt a generalisation as to whether this reduction is likely to be smaller, larger or equivalent??? In a Client/Server scenario however, it is quite likely that one would prefer the memory to be used in the Client, allowing more users for a given Server configuration. graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.