I was researching about MySQL performance for a new web project when I came across whit partitioning.
After reading Improving Database Performance with Partitioning and MySQL Partitioning, I thought "this is great, I'll use it", but after reading MySQL partitions tutorial, and since I'm using InnoDB, I though "maybe this is not such a good idea since storage may be a problem and the performance boost may not be that significant for this project".
In short, one has to perform some tests in order to decide.
./M6
Subscribe to:
Posts (Atom)