As long as your working set of data and indexes fit in RAM then it should perform well.