Thanks andy, it's a relief to know that using GUID is not really a recipe for disaster.

Most probably i will partition by projectID.

Since GUID has turned into chicken-egg arguments, wonder if anyone can really advise me on this issue:

Here's my scenario, a purchase order (PO) application:

We want to have a centralized...