Re: [Phpgroupware-developers] SQL Stored procedures?

[Alejandro Borges]

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.


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


Alex
SOG