Ticket #586 (new enhancement)

Opened 4 months ago

Last modified 3 days ago

DB partitioning by site_id

Reported by: gandalf Owned by: padams
Priority: blocker Milestone: Uncommitted Feature Requests
Component: base module Version:
Keywords: Cc:

Description

database should be refactored by allowing partitioning by site_id or something should me made to split sites over multiple databases or tables.

with tons of site, OWA is very very slow.

Change History

Changed 4 months ago by admin

  • milestone changed from 1.5.0 to Uncommitted Feature Requests

You can turn on mysql partitioning to partition the fact tables in any way you choose. If each site were to have it own table then there would be no good way to generate cross site statistics.

Also try adding indexes to the site_id columns in all fact tables.

Changed 3 days ago by iwdy24

rolex replica round usa

Note: See TracTickets for help on using tickets.