114 reputation
3
bio website appengineguru.com
location Chhatarpur, India
age 25
visits member for 2 years, 2 months
seen Feb 25 at 15:25

I am a Java Google App Engine Developer. I just love my work.


Jan
9
awarded  Supporter
Jan
9
comment Are NoSQL databases the best choice for more efficiently querying large amounts of data?
Thanks Julia, I am also planning to hybrid the SQL and NoSQL in the project as its more like a document kind of structure for hotels and similar products. Also the other tables will be in MySQL only as they are transaction tables.
Jan
9
comment Are NoSQL databases the best choice for more efficiently querying large amounts of data?
you are right that its more like a document. Also my searches and filters are usually on Name, Address, Star Ratings, Amenities, also I have already put indexes on my tables for this purposes. But again more the number of APIs I will integrate more will be the volume of data as Every Hotel can contain 20-30 amenities, 10-15 photos, 5-10 types of rooms and rooms may also contain photos and amenities.
Jan
9
comment Are NoSQL databases the best choice for more efficiently querying large amounts of data?
I am not storing any Binary Data, I am storing just URL for the images in the Images Table. Also the problem is not really of joining 4 tables and putting indexes as indexes I have already created, the problem is 1 hotel hotel may contain 50 amenities, 20 photos and 10 rooms and room may again contain 3-4 photos as well as amenities so this increases the time of search responses as it needs to scan so many tables aggregating there result set and sending to the UI.
Jan
9
awarded  Student
Jan
9
asked Are NoSQL databases the best choice for more efficiently querying large amounts of data?
Jan
4
awarded  Autobiographer