MSSQL and Redis database

[Manish]

how can i save data in MSSQL and Redis database. any one can help me?
I am developing an Social Networking website, and i have friendship
data model. i am developing this website using nodejs and my database
is ms sql 2008R2. now i would like to use "redis" for performance
purpose. but i don't know how can i do this? if you have any idea,
suggestions, let me know...

thanks...

[Josiah Carlson]

Redis is a type of database. To use it, you need to look at the
operations you are performing and the data that you are storing, and
you must map your current MSSQL database representation into something
that can be represented reasonably within Redis, and to which Redis
has fast commands for processing.

There have been at least a half-dozen threads in the last 6 months
about storing different parts of social networks in Redis, and I can
think of at least a dozen other threads that would have use-cases
similar to a social network.

Look through the archives, learn about Redis, then ask more questions
when you have a better idea of how Redis may be able to help you. It
is a lot easier to answer specific questions like "I want to do
operation X, would structure Y with commands Z be the best way?"

Regards,
- Josiah

> --
> You received this message because you are subscribed to the Google Groups "Redis DB" group.
> To post to this group, send email to redi...@googlegroups.com.
> To unsubscribe from this group, send email to redis-db+u...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/redis-db?hl=en.
>

[Demis Bellot]

These questions always gives me pause as it usually means the poster hasn't done any research of their own and are seeking silver bullets for their perf problems...

Redis is (amongst other things) a distributed data-structures server that requires a different mindset compared to an RDBMS when modelling your app.

I've tried to articulate some of these differences between RDBMS vs Redis design earlier here:

http://stackoverflow.com/a/8919931/85785

Redis is most-likely not going to be a drop-in replacement for your SQL Server db. 

In most cases adding a good caching strategy around your existing SQLServer-backed website/services will yield the best return for your effort, and if you have load-balanced servers that need distributed caching - Redis is an ideal choice.

Cheers,

--
You received this message because you are subscribed to the Google Groups "Redis DB" group.
To post to this group, send email to redi...@googlegroups.com.
To unsubscribe from this group, send email to redis-db+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/redis-db?hl=en.

--
- Demis

http://twitter.com/demisbellot

http://www.servicestack.net/mythz_blog