[Top][All Lists]
[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-----
- [Phpgroupware-users] PHPGW is Dang Slow, Joel Webb, 2003/07/01
- Re: [Phpgroupware-users] PHPGW is Dang Slow, Dave Hall, 2003/07/01
- Re: [Phpgroupware-users] PHPGW is Dang Slow, Chris Weiss, 2003/07/01
- Re: [Phpgroupware-users] PHPGW is Dang Slow, Chris Weiss, 2003/07/01
- RE: [Phpgroupware-users] PHPGW is Dang Slow, Chris Weiss, 2003/07/16
- RE: [Phpgroupware-users] PHPGW is Dang Slow, Brian Johnson, 2003/07/16
- RE: [Phpgroupware-users] PHPGW is Dang Slow, Chris Weiss, 2003/07/16