projects / freeside.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 654cded) | patch
Add in history_usernum and history_username indices. This allows for
authorJason (Jayce^) Hall <jayce@lug-nut.com>
Tue, 2 Sep 2014 17:00:08 +0000 (11:00 -0600)
committerJason (Jayce^) Hall <jayce@lug-nut.com>
Tue, 2 Sep 2014 17:00:08 +0000 (11:00 -0600)
commit3317a32f572a2e3605071410e7ddd8082e0b03ee
treeb79062d6098bcc10da1dad4a31d116ae58ff7758tree | snapshot
parent654cdedcfe361fc07669a5f9d1e094b8d26a4d39commit | diff
Add in history_usernum and history_username indices. This allows for
searches on *who* made changes to run faster. The best example of this
is on the homepage when it looks for the last modified customers by the
current user. On our system that query could take 5 minutes across so
many history records. Now takes a manageable amount of time with this
index
FS/FS/Schema.pm diff | blob | history
Freeside billing, trouble ticketing, network monitoring and provisioning