What is better? One database vs multiple databases under one engine.
- From: Vladimir.Sakharuk@xxxxxxxxx
- Date: 20 Jul 2005 07:11:16 -0700
Which scenario should give better performance for Sybase 12.
1 production database with all tables, views etc (of cause there are
standard databases ones here as well).
Multiple production databases with exactly the same total number of
objects but logically segregated.
like loadeddata reportdata etc...
Is there any performance drawbacks?
What kind of overhead should be expected one vs other?
What choice is faster?
What use more resources?
Thank you.
.
- Follow-Ups:
- Prev by Date: Performance Data need to be collected
- Next by Date: Locking Info
- Previous by thread: Performance Data need to be collected
- Next by thread: Re: What is better? One database vs multiple databases under one engine.
- Index(es):