4 ms·

I agree and should have been more precise. Most algorithm and data structure texts fail to deal with the issues surrounding secondary-storage application, inclu

• fleitz 16y ago
  Optimization is a black art. It generally only applies to very specific cases. This is why most RDBM systems expose a lot of knobs to tune. The DB must be tuned both to hardware and work load, what is a good idea for one workload may be a disaster for another. Here is an example, you can usually increase DB performance by about 15% by not allocating the first 8 MB of your hard drive. (Hint: the partition table causes misaligned reads/writes on raid systems if your partition starts at sector 1) If you want to see the tricks of the trade, go read the TPC results, find the auditor's report and look through the source, the hardware configuration, and the software configuration.