diff options
| author | ivan <ivan> | 2002-12-24 22:41:21 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2002-12-24 22:41:21 +0000 |
| commit | ca4988d84148e7d17cffdd84bb6867cbcf271531 (patch) | |
| tree | 04bec348a54e7fa9531a549f73316d8b9220a6c4 /httemplate/docs/upgrade9.html | |
| parent | dcf3808fb38f7d06721430db6a02f622cd4ee0dc (diff) | |
optimization for ginourmous numbers of packages for intergate, whew
Diffstat (limited to 'httemplate/docs/upgrade9.html')
| -rw-r--r-- | httemplate/docs/upgrade9.html | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade9.html b/httemplate/docs/upgrade9.html index da5b643fb..c6afe2b0f 100644 --- a/httemplate/docs/upgrade9.html +++ b/httemplate/docs/upgrade9.html @@ -15,6 +15,11 @@ INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 18, 'daytime', 'en_US', 'Day Phone' ); INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 19, 'night', 'en_US', 'Night Phone' ); </pre> + <li>Optionally, apply the following changes to your database (performance improvement for large numbers of services or packages): +<pre> +CREATE INDEX part_pkg1 ON part_pkg ( disabled ); +CREATE INDEX part_svc1 ON part_svc ( disabled ); +</pre> <li>If you want to use ACH (electronic checks), you will need to make changes to your database. The easiest way to make these changes is to dump your database (with pg_dump), change the payinfo field in the cust_pay, cust_refund, h_cust_pay and h_cust_refund tables from varchar(16) to varchar(80), reload the database from the dump, and run dbdef-create <li>Restart Apache and freeside-queued. </body> |