[Phpgroupware-tracker] [Bug #3384] Database/Performance problems

[nobody]

=================== BUG #3384: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3384&group_id=509

Submitted by: powerstat               Project: phpGroupWare                 
Submitted on: Tue 04/29/2003 at 11:19
Category:  API - phpGWapi             Bug Group:  devel cvs                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  None              
Platform Version:  None               Reproducibility:  None                

Summary:  Database/Performance problems

Original Submission:  The whole database is badly designed and to much work on 
the data is done in the API.
This will slow down the application!

Also other things that will slow down phpGW on the database level are 
missing(!!) indexes on "foreign keys" and other often used coloumns!!!

Another bad thing are relations between tables based on (var)char coloumns - 
this will also slow down the thing!

Last but not least it seems that to much data is doubled because each module 
invents the wheel again! This should be avoided.




No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3384&group_id=509