projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
75e7d01
)
update indices for better tax report performance
author
ivan
<ivan>
Sun, 25 Dec 2005 03:00:33 +0000
(
03:00
+0000)
committer
ivan
<ivan>
Sun, 25 Dec 2005 03:00:33 +0000
(
03:00
+0000)
FS/FS/Schema.pm
patch
|
blob
|
history
README.1.5.8
patch
|
blob
|
history
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
aaca5ef
..
7fc208f
100644
(file)
--- a/
FS/FS/Schema.pm
+++ b/
FS/FS/Schema.pm
@@
-334,7
+334,7
@@
sub tables_hashref {
],
'primary_key' => 'billpkgnum',
'unique' => [],
],
'primary_key' => 'billpkgnum',
'unique' => [],
- 'index' => [ ['invnum'] ],
+ 'index' => [ ['invnum']
, [ 'pkgnum' ]
],
},
'cust_bill_pkg_detail' => {
},
'cust_bill_pkg_detail' => {
@@
-433,6
+433,8
@@
sub tables_hashref {
#'index' => [ ['last'], ['company'] ],
'index' => [ ['last'], [ 'company' ], [ 'referral_custnum' ],
[ 'daytime' ], [ 'night' ], [ 'fax' ], [ 'refnum' ],
#'index' => [ ['last'], ['company'] ],
'index' => [ ['last'], [ 'company' ], [ 'referral_custnum' ],
[ 'daytime' ], [ 'night' ], [ 'fax' ], [ 'refnum' ],
+ [ 'ship_last' ], [ 'ship_company' ],
+ [ 'county' ], [ 'state' ], [ 'country' ]
],
},
],
},
@@
-465,7
+467,7
@@
sub tables_hashref {
'primary_key' => 'taxnum',
'unique' => [],
# 'unique' => [ ['taxnum'], ['state', 'county'] ],
'primary_key' => 'taxnum',
'unique' => [],
# 'unique' => [ ['taxnum'], ['state', 'county'] ],
- 'index' => [],
+ 'index' => [
[ 'county' ], [ 'state' ], [ 'country' ]
],
},
'cust_pay' => {
},
'cust_pay' => {
diff --git
a/README.1.5.8
b/README.1.5.8
index
73a85a2
..
cf41454
100644
(file)
--- a/
README.1.5.8
+++ b/
README.1.5.8
@@
-17,6
+17,14
@@
run "freeside-upgrade username" to uprade your database schema
Optional:
CREATE INDEX cust_pkg2 ON cust_pkg ( pkgpart );
Optional:
CREATE INDEX cust_pkg2 ON cust_pkg ( pkgpart );
+CREATE INDEX cust_bill_pkg2 ON cust_bill_pkg ( pkgnum );
+CREATE INDEX cust_main9 ON cust_main ( county );
+CREATE INDEX cust_main10 ON cust_main ( state );
+CREATE INDEX cust_main11 ON cust_main ( country );
+CREATE INDEX cust_main_county1 ON cust_main_county ( county );
+CREATE INDEX cust_main_county2 ON cust_main_county ( state );
+CREATE INDEX cust_main_county3 ON cust_main_county ( country );
+
Optional for better VoIP performance:
CREATE INDEX rate_detail2 ON rate_detail ( ratenum, dest_regionnum );
Optional for better VoIP performance:
CREATE INDEX rate_detail2 ON rate_detail ( ratenum, dest_regionnum );