I've been using Cloudscape for quite a while in an application that hardly exercises it to its limits - relatively small amounts of data, few time critical functions, etc.. I gather that IBM is positioning Cloudscape as something of an entry-level product that one might migrate from when demands become too great, and move to DB2. As I'm preparing to move from an old version of Cloudscape to Derby, I'm wondering if Derby might actually be able to to accommodate larger datasets and support faster access than its positioning might suggest. This will be a servlet based system with up to ~100 concurrent users, each reading/writing data in 5-10K byte chunks every few seconds - this needs to be done in a timely manner. I'm not sure yet what our size limit on accumulated data would be, but bigger would of course be better.

Are there any opinions as to whether such a system might need to abandon Derby in favor of DB2 or something else, and if so what the approximate limits are? All opinions welcome.

Rick Strong




Reply via email to