After reading through all the other replies, I'm really interested in seeing suggestions on the search and sorting operation that needs to be done with every wr

After reading through all the other replies, I'm really interested in seeing suggestions on the search and sorting operation that needs to be done with every write. Realizing that if the query returns a huge number of records, sorting and feteching those records will be THE bottleneck.