All Questions
10
questions
0
votes
1
answer
618
views
In MongoDB, what is the time complexity of a query to find all records with row ids not in a given list?
I have a pre defined array, A, containing an arbitrary number of row ids for a particular table.
The query is to find all records / rows of this table that have row ids not contained in A.
What is ...
3
votes
0
answers
3k
views
PostgreSQL jsonb slower than hstore for large sets of key->value
I'm converting composite type into one of NoSQL types and have done performance tests for hstore and jsonb. For some reason jsonb gets slower the more key->value pairs there is.
My current type looks ...
- 5,820
-3
votes
2
answers
161
views
MySql database for lot of data [closed]
I want to create an mobile app that need to send data every minute to backend server with mysql database.
So if I have 10 000 users that work 8 hours a day that will be:
60 request * 8 hours * 30 ...
- 169
1
vote
1
answer
134
views
Two types of data, so two type of databases?
For a social network site, I need to propose a DB. The application is written in Java & will be hosted on VPS(s) initially.
Broadly classified there is two type of data to be stored at backend:
...
- 26.3k
2
votes
1
answer
272
views
Is Transaction Script an antipattern with NoSQL databases also?
http://martinfowler.com/articles/dblogic.html
Using the terminology of the above article, the Transaction Script pattern of coding is clearly an antipattern when dealing with SQL databases.
Is the ...
- 3,813
2
votes
2
answers
831
views
Using MySQL or NoSQL database [closed]
I'm going to start a large web application, the app will be powered by PHP (YiiFramework), and I wish to build before launching the app a strong and high scalability architecture able to handle huge ...
- 1,085
54
votes
3
answers
22k
views
Any detailed and specific reasons for Why MongoDB is much faster than SQL DBs?
Ok, there are questions about Why Is MongoDB So Fast
I appreciate those answers, however, they are quite general. Yes, I know:
MongoDB is document-based, then why being document-based can lead to
...
- 25.7k
3
votes
1
answer
3k
views
Geographic queries in NoSQL
Our team is currently working on some killer ios location app that we fear "explode" in a good way, so we want to put effort thinking about scalability and Availability.
After we read that draw ...
- 6,653
5
votes
1
answer
2k
views
Sql database versus document database?
Small introduction:
I've tried to develop my project with sql database, entity framework, linq.
I have table 'Users' and for example i have list of user educations. I ask myself: 'How much ...
- 53.5k
9
votes
5
answers
5k
views
Scalability of Using MySQL as a Key/Value Database
I am interested to know the performance impacts of using MySQL as a key-value database vs. say Redis/MongoDB/CouchDB. I have used both Redis and CouchDB in the past so I'm very familiar with their ...
- 77.9k