All Questions
13
questions
2
votes
1
answer
152
views
How to perform a query having pseudo-relations between two distinct database types?
In a nutshell, the title best discribes my question, but here I am showing the core of the problem.
I have two databases in my web application, One is MariaDB, the other is MongoDB, To give some ...
- 869
0
votes
0
answers
171
views
Sql + ElasticSearch or NoSQL? Also, can I do this with existing PHP code
I know that there is an abundance of articles and questions to related topic and I Have been researching them from a few days now and I am more confused then ever.
I am newbie to website world and I ...
- 1
0
votes
1
answer
95
views
bulk update mongo records
I have a large sharded mongo collection (totaling around 16 million records) that I need to go through and add an attribute to. On the current server, writing a script to loop through these and check ...
- 10.2k
-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
2
answers
200
views
Keeping track of users and photos they've viewed
I have a very high traffic site with lots of photos on it and am trying to track which photo each user has viewed.
My first instinct would be a SQL table with two columns: user_id & photo_id. ...
- 5,669
0
votes
2
answers
129
views
How to conditionally find items by Tag in mongodb
I am new to NoSQL and MongoDB and I am a little puzzled on what type of queries I can do and how to do them. my knowledge is limited to simpler queries
I would like to make what I think its a ...
- 4,153
0
votes
1
answer
481
views
What's the best way to manage read/unread items (NoSQL/SQL)? [closed]
I'm going to build a Symfony 2.1 application which needs to know the state of items (read/unread), are there any efficient methods to save item states (with many items) ? Using SQL relationnal table ...
- 553
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
0
votes
1
answer
475
views
Symfony Model abstraction (to SQL or NoSQL)
I am starting a new (and first) project with Symfony2, but I didn't choise Database engine yet. And it could be MySQL or NoSQL engines like MongoDB or others, or also it could be changed along the ...
- 800
-1
votes
2
answers
362
views
What is the best architecture to use at the back end for a java client based client/server setup?
I'm fairly new to programming and have been focussing a great deal on Java in recent months. I would like to write an application with a Java applet front end which will capture information about my ...
- 177
2
votes
1
answer
398
views
MongoDB/NoSQL Performance and Design
I have a question that involves a performance question and Mongo
Design. Currently a project I am working on will involve notifications
similar to Facebook where a user will receive messages on things ...
- 12.1k
2
votes
2
answers
357
views
Moving from Mysql to nosql later. Code requirements?
When switching between a RDMS (MySQL) to a Graph or Document database, does it require much application code changes or a complete re-write of code? I am using MySQL but plan to switch over in about 5-...
- 43
6
votes
3
answers
7k
views
MongoDB, Complex Queries, and Performance
Back-Story
On a current project, I am using MySQL and SQLite in combination with each other. I'm currently giving each user their own SQLite database to get around my provider's 1GB MySQL DB limit. ...
- 20.7k