Re: [Phpgroupware-developers] SQL Stored procedures?

[Dan Kuykendall (Seek3r)]

Alejandro Borges wrote:
> 
> El jue, 23-05-2002 a las 03:02, Roy Sigurd Karlsbakk escribió:
> > hi
> >
> > wouldn't using SQL stored procedures on those DBMSes that support it, result
> > in a major performance boom? Has anyone tried? What's the down-sides of 
> > using
> > them?
> 
> An easyer shorter term goal would be to produce (hack arround setup's
> code) real imported indexes and such optimizations per database
> brand.... thats easyer and still needs to be done. As of now, if you use
> postgres, you get a mysql-limited design (no foreign keys)... A revision
> of generated tables and more thorough testing would help out a lot.

Right. This is the kind of thing that would be useful for performance
improvements. We might be able to imcorporate these db specific
performance tweaks into the setup prog as well

> Ive done quite a bit of testing and will be releasing some docs on a few
> tweaks to a  postgres instalation to gain performance. Im shure others
> here can also complement that cause there are instalations with
> thousends of users (that thing u said about concurency is not a database
> problem).....K Buy

Look forward to seeing them

Dan