question Re: What is the difference between SQL and NO sql? Which one is faster?? in Archives of Support Questions (Read Only)

What is the difference between SQL and NO sql? Which one is faster??

rammohanciber — Sat, 11 Mar 2017 14:14:42 GMT

While executing a query in SQL and No SQL which will execute first??

Re: What is the difference between SQL and NO sql? Which one is faster??

bandarusridhar1 — Sat, 11 Mar 2017 22:55:58 GMT

@Rammohan ReddyDepends on your use case we can say which one will be faster.

NoSQL vs SQL comparison

The following table compares the main differences between NoSQL and SQL.

Hope this link helps you:

http://www.thegeekstuff.com/2014/01/sql-vs-nosql-db/?utm_source=tuicool

https://www.dezyre.com/article/nosql-vs-sql-4-reasons-why-nosql-is-better-for-big-data-applications/86

https://docs.microsoft.com/en-us/azure/documentdb/documentdb-nosql-vs-sql

Re: What is the difference between SQL and NO sql? Which one is faster??

rammohanciber — Sun, 12 Mar 2017 01:35:42 GMT

Hi,

Thanks for the response and would like to know that if am execute the query in Hive and in oracle which one will execute fast? If your answer is hive then please explain me. Hope reply from you soon.

Regards,

Ram

Re: What is the difference between SQL and NO sql? Which one is faster??

bandarusridhar1 — Sun, 12 Mar 2017 04:46:38 GMT

@Rammohan Reddy

If you are executing query on smaller dataset, Oracle will be much faster. If you are executing queries on larger dataset, Hive will faster again depends on compute power

Re: What is the difference between SQL and NO sql? Which one is faster??

rammohanciber — Mon, 13 Mar 2017 09:14:07 GMT

Thanks for the explanation.