[comp.os.vms] Rdb

mcclure@tut.cis.ohio-state.edu (James Edward McClure) (07/14/88)

I am in the process of designing a database using Rdb and never having
used Rdb before I was wondering how well it performed.  The database will
contain about 5 tables.  I'll be doing queries on a view that will cross
4 of the 5 tables and was curious about the speed.  Any information is
greatly appreciated.

Thanks.

reden@sys1.TANDY.COM (07/17/88)

>I am in the process of designing a database using Rdb and never having
>used Rdb before I was wondering how well it performed.  

I am currently using RDB with a Datagrive interface to maintain hardware
and software information for our network.  Overall, I like it.  It's very 
flexible in the way you can set up your data and I like the ability (and have
used it) to change relation data structures at will.               

I have found my database to be rather slow, especially at startup.  I think
this is mostly due to Datagrive being slow.  I did notice a very large 
improvement when I added indexes to the relations.  Adding constraints did
slow things down a lot though.  I think updating constraints at COMMIT time
does decrease the loading.

The only problems I have had deal with Datagrive, but it is more conveienent
that writing your own program and a little more powerfull than RDO.

Hope this helps...    

Robert

reden@sys1.uucp