We have been evaluating the InfiniDB Community Edition. We have been running PostgreSQL and are currently running both on identical servers. When I run any sort of count on the InfiniDB machine it will generally beat PostgreSQL hands down. This works well for getting quick information out of the database and we were planning to standardize on InfiniDB.
The problem is, when I try to do a match and retrieve data PostgreSQL is much faster. At first I assume this might have something to do with using the substring function, so I took a common substring we use and put it in it's own column. The column is 16 char long, and I just select where column = 'something' on it. Even with this column set up, running about 150k selects takes some 30 minutes on PostgreSQL while checking about 500 million rows, but I have allow InfiniDB to run all night and into the next day without finishing.
Is there a setting I need to be looking at or is InfiniDB just not build to handle rapid fire queries like that? I am running them one at a time on each DB.