phpgroupware-tracker
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-tracker] [support #102268] Choosable MySQL table prefix


From: nobody
Subject: [Phpgroupware-tracker] [support #102268] Choosable MySQL table prefix
Date: Sun, 13 Jul 2003 18:28:15 -0400
User-agent: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.3.1) Gecko/20030425


Support Request #102268, was updated on Mon 07/14/2003 at 03:50
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=102268&group_id=509

Category: Feature Request
Status: Open
Priority: 5
Summary: Choosable MySQL table prefix

By: skwashd
Date: Mon 07/14/2003 at 08:28
Logged In: YES 
user_id=2480
Browser: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.3.1) Gecko/20030425

There was a discusssion of this a long ago (about 2years
ago).  I have spent some time trying to find the thread in
the old sf.net mail archives - but they don't really support
searching.

The result of the old discussion was prepending phpgw_ to
all table names.

A few points to keep in mind though.

Performance
Prepending the table prefix to each query would add a
performance hit.  For example to render a page creates about
10 queries - for a normal app.  So it many only be a
fraction of a second each time the prefix is added, but this
soon adds up.

Work
This is a lot of work to implement this, and it will break
stuff for quite a while.  Every query in every app will need
to be changed, setup/update scripts written, and something
added to the header.  This will also needed to be thoroughly
tested.  At the moment we are quite thin on the ground, and
I know many of our devs have high priority items.

Cost Benefit Analysis
I see this only being of benefit to users with very
restricted hosting deals.  Whereas making the change we
create a lot of work, add an extra point of failure, and
degrade performance.  Maybe you could shop around for a new
host - such as www.finalhost.net (sponsored advertisement).

I will close this report and forward it to the developer 
list - phpgroupware-developers at gnu.org ... you can either
read the discussion in the archives
(http://mail.gnu.org/archive/html/phpgroupware-developers/2003-07/threads.html)
it is upto 24hours behind or subscribe to the
list(http://mail.gnu.org/mailman/listinfo/phpgroupware-developers).

Cheers

----------------------------------------------------------------------

By: kosmo
Date: Mon 07/14/2003 at 03:50
Logged In: NO 
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)

A user-defined MySQL prefix for tables would be nice. 
This would be useful for people who want to have two 
versions (eg. stable & cvs) linked to the same 
database. Unfortunately, most hosts only offer a 
limited amount of MySQL (and other) databases in their 
plans.

----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=102268&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/





reply via email to

[Prev in Thread] Current Thread [Next in Thread]