All Questions

Tagged with
Filter by
Sorted by
Tagged with
1
vote
1answer
682 views

SQL Server Latching from Multithreading/Parallel Inserts and Hash Partitioning

We are conducting parallel, multithreading inserts in SQL server tables, and want to reduce latching. What are the disadvantages of utilizing hash partitioning to reduce latching? Is it reduced ...
1
vote
0answers
61 views

MySQL partitioning by hash not repeatable

I have a MySQL (5.6.17) table with a few million records that I wish to partition. In order to do this, I use this query: ALTER TABLE tablename PARTITION BY HASH(id) PARTITIONS 8; Seems to ...