Re: [Phpgroupware-developers] SQL Stored procedures?

[Dan Kuykendall (Seek3r)]

Roy Sigurd Karlsbakk wrote:
> 
> > it might, but it would not only take major additions to the setup code to
> > support it, but would require most apps to be rewritten to call sp's
> > instead of executing sql, thus totaly defeating the database abstraction.
> > The whole idea behind phpgwapi's database class is that the app programmer
> > doesn't need to care what database is behind it, he/she just uses standard
> > SQL statements.  And if this is followed, the app will magically work on
> > all databases that phpgw supports without furthur porting.
> 
> sure. but today's design is SLOW and doesn't scale above a few number of
> concurrent users

There are ways to improve performance without using stored procedures.
Also after years of DB admin responsibilties I have learned well that
SP's are not a magic bullet for performance. Their biggest benefit is in
centralzing control over data access and retrieval, NOT performance. In
some cases they will improve performance a little, but thats not where I
feel they are valuable.

Also to say that phpGW can only handle a few concurrent users is a joke.
I have an install at a public school that runs on a P133 with 128MB. It
runs RedHat with PHP4. I have it setup to use PHP4 sessions and
phpgwinfo array caching. The box is regularly in use by 60+ students and
facilty concurrently.
The phpgroupware.org demo is also hit hard during releases and is
running on a fairly small server as well.

We are always looking for ways to increase performance and if you have
ideas, present them so that we can look at the merits and if they are
good we would look at implementing them.

Dan Kuykendall