New answers tagged

1

As an alternative, if you have Solr already set up, you can have it index your document and return it to you in multiple formats (JSON, XML, even Python dictionaries). Solr offers a way to search through your information really fast as well as allowing you to do faceted queries as well. While creating your own denormalized structure in a RDBMS would ...


0

I work in an organisation that has implemented RDBMS and NoSQL databases (Hadoop). We're looking at getting rid of the RDBMS as it is not as flexible as it needs to be for constantly changing data. So NoSQL would be the way to go. And we use OOP. With OOP you can use a mixture of both databases as we are doing now. It does not have to stop at the RDBMS. ...


2

If I had more reputation, I would add a comment asking you to describe your indexes. As it is, I'll assume you don't have indexes since you didn't mention them. First, consider using EXPLAIN on your queries to analyze the decisions the planner makes. 1.5m rows shouldn't take 20 seconds with any sort of reasonable combination of hardware and indexing. See ...



Top 50 recent answers are included