Solar

Solar is designed for search i mean it's key value store basically but it's designed to find things quickly as compared to a sequel table. We're using Drupal and as a psp templity on the front end and just as a proof of concept i wrote a view front end that searched a given index and and had pagination and all kind of stuff. It was so much faster going through solar i could literally click and it was instantaneous paginating through results finding results much quicker than anything i'd ever seen in sequel. From a size standpoint putting stuff in solar you know we had a lot more room there i guess in flexibility than we did dumping hundreds of thousands of records into my sequel