Re: Creating & accessing a database across CDs

Hi,

I once developed a very large database using database a CD Jukebox as a database device in Sybase. It worked very well but there are several things you will want to consider.

It's very important that you understand the physical characteristics of how your CD drive works and the impact that will have on the database server. Some of the questions you should ask are:

        How is the data joined? Tables that are often joined should be on the same side of the same CD.

        When spanning, what impact will spanning a device across both sides of the same CD have? Can you CD drive read 2 sides of 1 CD simultaniously?

        What about spanning database devices across multiple CDs? Casn your drive read more than 1 CD at a time? How fast is the "swap" rate?

Also, you have to be careful with your database design. In Sybase specifically by example, you do NOT want tempdb, your master device, or logdevices on CDs. I can't emphasize enough how important this will be to performance. If you're not using Sybase, the basic idea is you want *only* data devices to reside on the CD.

Hope this helps

drew <drew_at_cyberway.com.sg> wrote:

>Hi,
 

>I'm trying to create a series of 6 CDs containing a database of names
>and addresses.... the amount of data is quite huge -- about 3-4 gig --
>and it consists of many tables with links to be accessed using
>Powerbuilder....
 

>Has anyone out there created something like this before? Which
>databases should I use that can support spanning? Or should I consider
>another storage media instead of using CDs?
 

>Thanks,
>Drew
Received on Fri Sep 05 1997 - 00:00:00 CDT