[Top][All Lists]
[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/