Re: [ROOT] ROOT versus SGBD

From: Fons Rademakers (
Date: Mon Nov 22 2004 - 12:43:59 MET

Hi Ivan,

 depends what you want to store and how you want to store it. Use a
MySQL DB when you have many concurrent inserts and/or updates (ROOT has
no concurrency mechanism built-in). If your DB is mainly readonly and
efficient access is needed have a look at the ROOT DB, it is quite more
efficient querying and due to the built-in compression mechanism files
are much smaller.

For more info on this subject see:

Cheers, Fons.

On Sat, 2004-11-20 at 20:33, Ivan Koga wrote:
> Hi everybody,
> I'm new on ROOT and I was questioned about the ROOT performance. Is ROOT 
> better to store data than a SGBD like MySQL? If it's true or false... why?
> Does anybody knows how to answer this questions?
> Thank you,
> Ivan K. Koga
Org:    CERN, European Laboratory for Particle Physics.
Mail:   1211 Geneve 23, Switzerland
E-Mail:              Phone: +41 22 7679248
WWW:      Fax:   +41 22 7679480

This archive was generated by hypermail 2b29 : Sun Jan 02 2005 - 05:50:10 MET