database-partitioning
database partitioning explanation
I just read about database partitioning and still have some confusion about it. So anybody please give me some explanations about what were changed in term of disk storage(like data file, index file,[详细]
2023-02-04 04:51 分类:问答SQL Server partition table performance
I am using SQL Server 2008 Enterprise. I have yea开发者_如何转开发rly customer data from 2000 to 2010, and from 2000 to 2009, I only need to read, and in the year of 2010, I need both read and write.[详细]
2023-02-01 05:34 分类:问答SQL complex view for virtually showing data
I have a table with the following table. ---------------------------------- HourLocationStock ----------------------------------[详细]
2023-01-31 20:12 分类:问答Too many columns to index - use mySQL Partitions?
We have an application with a table with 20+ columns that are all searchable. Building indexes for all these columns would make write queries very slow; and any really useful index would often have to[详细]
2023-01-30 21:04 分类:问答Design recommendations for a history/audit table
I need to keep track of many items and their states throughout time. Example ItemId LocationDateTimeState[详细]
2023-01-30 04:08 分类:问答How does one do a SQL select over multiple partitions?
Is there a开发者_如何学Go more efficient way than: select * from transactions partition( partition1 )[详细]
2023-01-26 23:27 分类:问答Way to map partitioned data using NHibernate
We have a scenario where active records are stored in one table and over time old records are archived. The table structures for the two tables - active and archive are exactly the same.[详细]
2023-01-25 01:15 分类:问答Want to move MySQL Datadir to another partition
I\'d like to move all my mysql databases to another parition. I\'ve tried the brazillion guides out there but I\'ve not found anything that works![详细]
2023-01-24 17:29 分类:问答PostgreSQL+table partitioning: inefficient max() and min()
I have a huge partitioned table stored at a PostgreSQL table. Each child table has an index and a check constraint on its id, e.g. (irrelevant deatils removed for clarity):[详细]
2023-01-19 11:39 分类:问答How to scale out by evolving from database partitions to sharding?
Say I have a MySQL table: CREATE TABLE tweets ( tweet_id INT NOT NULL AUTO_INCREMENT, author_id INT NOT NULL,[详细]
2023-01-12 15:47 分类:问答