I have a DB that stores strings of XML. There could be hundreds of
those, thousands at most.
Based on client requests, a binary file is generated, most of the
content in the binary file is XML taken from the DB. So there is plenty
of parsing to do and several searches to collect the right pieces of XML
that I need.
I need persistence so I still need the DB and ActiveRecord. But I
thought that if I could copy the DB into memory to speed up.
This sounds like I could start playing with memcache.
But somewhere I read that memcache will only be faster when dealing with
millions of records. I won’t have millions of records so will this
really bring me any benefits? The load from clients is expected to be
I’d appreciate your opinions.
I will be playing with memcache in the meanwhile as well.