phpgroupware-users
[Top][All Lists]
Advanced

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

RE: [Phpgroupware-users] PHPGW is Dang Slow


From: Tomasz Spyrczak
Subject: RE: [Phpgroupware-users] PHPGW is Dang Slow
Date: Wed, 16 Jul 2003 14:02:33 +0200

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi there

In my production system I've temporarily dumped all the database
tables with their definitions (using "pg_dump" in PostgreSQL). Then I
manually changed all TEXT fields to apropriate VARCHAR fields. And
then I reinstantiated the database using the changed tables
definitions.

Of course before changing types of fields from TEXT to VARCHAR, I
first measured maximum occured length of content of each modified
field. I assumed that length of double of what I had in my database
would be enough.

In case of a fresh install, it is good to hack around and modify
apropriate fuctions in setup/inc/class.shema_proc_??slq.inc.php -
TranslateType() and rTranslateTime(). These are the functions that
mess with the database structure creation and that "translate" :-(
longer varchar fields to text fields.

Moreover one should also review setup/tables_current.int.php files in
all used applications and phpgwapi, to "find and destroy", er.. I
mean to change all definitions of TEXT fields to VARCHAR definitions,
supplying of course some proper VARCHAR lengths.

Anyway here is one of internal api tables in my installation:

            Table "phpgw_app_sessions"
   Column    |          Type           | Modifiers
- -------------+-------------------------+-----------
 sessionid   | character varying(255)  | not null
 loginid     | character varying(20)   |
 location    | character varying(255)  |
 app         | character varying(20)   |
 content     | character varying(1020) |
 session_dla | integer                 |

This one is the very table (when with "content" defined as "text")
for the long login times. Check out its original definition in
phpgwapi/setup/table_current.inc.php - at least in phpgw ver.
0.9.14.003 it is defined as "text" in that file.

Best regards
Tomasz Spyrczak

> -----Original Message-----
> From: address@hidden 
> [mailto:address@hidden 
> Behalf Of Hsing-Foo Wang
> Sent: Wednesday, July 16, 2003 11:50 AM
> To: address@hidden
> Subject: Re: [Phpgroupware-users] PHPGW is Dang Slow
> 
> 
> Hi Tomasz,
> 
> What exactly did you do, I mean looking at the tables what type of
> field  did you altered into whta type?
> 
> Can you give an exact example of 1 of the tables in phpwg
> 
> Thx
> Hsing-Foo

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>

iQA/AwUBPxUwhMbMsgKq/FYXEQIwLgCgimPnc0+ron+uCczblYz6bDVz64cAoKWg
UpigIRk+A1D1zeMeWPCl3R1x
=QVkc
-----END PGP SIGNATURE-----





reply via email to

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