2
votes
Partitioning vs Archiving Data for a specific use case
currently there's no performance issues but we are anticipating the growth, where at some point there's going to be issues in queries.
Partitioning isn't a general query performance feature - if you ...
1
vote
Optimise query for fetching data across multiple days in a partitioned table
Your standards are very high here and might not be attainable.
As your date range increases, you get less and less benefit from partitioning by date. Indeed, it might already be counterproductive, as ...
1
vote
MySQL partition failed
You can't compare DATE with string or any other values, the best way to do it assuming the filed type you are using is date is using an embedded function in MySQL TO_DAYS, you need to change the than (...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
partitioning × 960sql-server × 351
mysql × 200
postgresql × 176
performance × 98
oracle × 90
index × 74
database-design × 53
sql-server-2012 × 47
sql-server-2014 × 47
sql-server-2008-r2 × 39
sql-server-2008 × 38
sql-server-2016 × 37
query-performance × 34
innodb × 34
optimization × 26
trigger × 19
oracle-11g-r2 × 17
table × 17
mysql-5.7 × 16
sharding × 16
mysql-5.6 × 15
sql-server-2017 × 15
postgresql-performance × 15
oracle-11g × 15