search

killbill / killbill-plugin-framework-ruby

Framework to write Kill Bill plugins in Ruby
http://killbill.io
8 stars 11 forks source link

Missing indexes #45

Open pierre opened 9 years ago

pierre commented 9 years ago

Adding an index on responses(kb_payment_id, kb_tenant_id) seems to do the trick.

pierre commented 9 years ago

Adding one on transactions(XXX_response_id) seems to help too.

pierre commented 9 years ago

For CyberSource:

create index cybersource_responses_idx on cybersource_responses(kb_payment_id, kb_tenant_id);
create index cybersource_transactions_idx on cybersource_transactions(cybersource_response_id);