postgres or mysql?

[dico]

Hi there,

I am working on a project that has roughly 1000 DBs, each with about 5 tables (maximum 100,000 records per table). I will be running queries across all 1000 DBs and their tables. This would be a pretty big query I would think. I am wondering which DB would handle this better.

Thanks,

-dr

[chriskl]

There's just no way to answer that question without knowing the kinds of queries you want to run.

If you want to run queries BETWEEN databases, then you need mysql. Otherwise, use PostgreSQL's schemas.

Chris

[dico]

It would be between databases. Is there any good tutorials on how to properly and efficiently search between multiple databases?

Thanks,

dr