mysql with mongoDB & how to use join...?

[종훈 서]

1. mongoDB a good way to use with mysql?
Member information using MYSQL, and the rest will try to use mongodb.
Is there a problem?

2. MYSQL in the "join" How to use?
For example, a list of friends and have a list of feeds. Loads of my
friends have to feed.
mysql use a join. But the performance is too bad. I will try to use
mongoDB. In this case, the query twice mongoDB do? Loading friends
list, and re-load the feed do?

I need a good advice.

[Sam Millman]

"Member information using MYSQL, and the rest will try to use mongodb.
Is there a problem?"

Sounds like you want this part to run client side connecting to the two db's on different connections. No ther is no problem.

2. To do joins in Mongo you would, as you say, load the contents of one table then load the query based contents of another table. This is generally faster since you do not require complex queries and analyzers to perform the query and ensure success.

Unfortunately I cannot give you good advice on your strategy without knowing more about your shcema, querying and scenario.

If you would like further help please post more information.

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

[Andreas Jung]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sam Millman wrote:
> "Member information using MYSQL, and the rest will try to use
> mongodb. Is there a problem?"
>
> Sounds like you want this part to run client side connecting to the
> two db's on different connections. No ther is no problem.
>
> 2. To do joins in Mongo you would, as you say, load the contents of
> one table then load the query based contents of another table. This
> is generally faster since you do not require complex queries and
> analyzers to perform the query and ensure success.
>
> Unfortunately I cannot give you good advice on your strategy without
> knowing more about your shcema, querying and scenario.

Standard answer:

- - denormalization
- - using embedded docs
- - performing multiple queries

as "replacement" for JOINs

- -aj

>
> If you would like further help please post more information.
>
> On 6 September 2011 19:01, 종훈 서 <jongh...@gmail.com

> <mailto:jongh...@gmail.com>> wrote:
>
> 1. mongoDB a good way to use with mysql? Member information using
> MYSQL, and the rest will try to use mongodb. Is there a problem?
>
> 2. MYSQL in the "join" How to use? For example, a list of friends and
> have a list of feeds. Loads of my friends have to feed. mysql use a
> join. But the performance is too bad. I will try to use mongoDB. In
> this case, the query twice mongoDB do? Loading friends list, and
> re-load the feed do?
>
> I need a good advice.
>
> -- You received this message because you are subscribed to the
> Google Groups "mongodb-user" group. To post to this group, send email
> to mongod...@googlegroups.com

> <mailto:mongod...@googlegroups.com>. To unsubscribe from this

> group, send email to mongodb-user...@googlegroups.com

> <mailto:mongodb-user%2Bunsu...@googlegroups.com>. For more

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

- --
ZOPYX Limited | zopyx group
Charlottenstr. 37/1 | The full-service network for Zope & Plone
D-72070 Tübingen | Produce & Publish
www.zopyx.com | www.produce-and-publish.com
- ------------------------------------------------------------------------
E-Publishing, Python, Zope & Plone development, Consulting

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJOZmZ6AAoJEADcfz7u4AZjwxALwLbUyEbhQJoqktlA0zTIsvIX
R+NCYNf/uAWxnaK2vTz66gRIMv/bduoD0si3cBUS+6hDfgx5rXhFfzNL/+N2Ug3B
AAyHmeCa/LHToig1n4cO5ESlMbQTFHkmB2lcFaS7/5GGGyAt1fLY1baajyHpslum
T9LFLmS0otr6HH4ed7E9/Uji5luDUPO9+iQqkd+9hjmPa4fSXVcjVOKC/WWO9xdC
Kk5sPiuZqnu0KgY1xrU/X6hHkEGeqbMcKOK8DTdtEfq4lstJ0lYPQvV+yY4YEIYu
mv9RXftwB/gYK9qS5sDxuVnFuXKxKMqybnXXQhip8n/KPLkv1lLZ+5aWrq7xfUyj
5c8iGY8pgtI5o/frIvAlADAD6/7la0PlsTx0hmAdM6QzD1hN1tXyV9+dtOMzBg4W
o427Q8Vsi/NESkkBmr6UHDU1vNHYSu0Y1ho4tiYgUlnIrmRgTeICp68iNwzMCDml
Rx6md7BLYLggYExAokf2SMiHnOOwRhs=
=Snrj
-----END PGP SIGNATURE-----