I have been trying to implement Given URLs solution.

Can anyone please help me ?

promotion

One more question , I am more concern about database design also, e.g. Table designs and its relationship , data model like scalable DB Design like , when we grow our features/Buisness DB should not be big barrier

This might also be helpful

https://www.holistics.io/books/setup-analytics/

http://www.odbms.org/wp-content/uploads/2013/11/PP2.pdf This could be a good starting point.

followed by further reading on this https://www.ciosummits.com/media/solution_spotlight/TDWI_Che... And possibly sql query optimizations. In most cases, efficient indexes should be enough to maintain reasonable performance.

But in cases where scale gets exponentially bigger at a rate at which you cannot possibly keep adding computing resources, breaking the best followed practices is the only way to get more performance without adding hardware resources at the same rate as increased scale, this at times includes but is not limited to, getting rid of foreign keys, coupling your app logic along with your db to to breakdown larger tables periodically/automatically/ runtime creation. This though requires skills across the entire stack and has it's fair share of downfalls and is never a recommended practice unless you know what you're doing and are okay with compromising on some of ACID properties. since maintaining something like this becomes unsustainable without contingencies. Take all of this with some grain of salt as the topic is highly subjective.

Thanks 9notrop,

Yes i will check that book and it will be helpful, for Node vs Apache, yes , as Apache is multi threaded and Node is single threaded ,if some fails single thread will die and it affect whole server

i didn't understand site, is below list is zero data app ?

Shopshastra is one of the Mumbai based startup , you can get from their https://www.shopshastra.com/