RE: is TTreeSQL dumping the whole table ?

From: Philippe Canal <pcanal_at_fnal.gov>
Date: Wed, 01 Feb 2006 10:38:21 -0600

Hi Tristan,

The size of the database should not cause a crash. However there was a bug recently fixed (in the CVS repository) that provoked a crash if the table contain any character string columns.

Please try with ROOT from the head of the repository. If it still does not work, please send me a stack trace of where it crashed.

Cheers,
Philippe.

-----Original Message-----

From: owner-roottalk_at_pcroot.cern.ch [mailto:owner-roottalk_at_pcroot.cern.ch] On Behalf Of Tristan Beau
Sent: Wednesday, February 01, 2006 9:31 AM To: roottalk_at_pcroot.cern.ch
Subject: [ROOT] is TTreeSQL dumping the whole table ?

Hello,

   I just discovered the new classe TTreeSQL. I tried to use it with a code such as :

TSQLServer *s = TSQLServer::Connect("mysql://dbserv/db","user","pwd"); TTreeSQL *t = new TTreeSQL(s,"db","atable");

   But then it crashes my session probably because the "atable" table is too big. Is TTreeSQL dumping the whole table with the constructor TTreeSQL ? This is a problem while accessing to very big tables ( > 1 Go ). Which way should I use in such a case ?

   Thank's in advance,

                                Tristan



---

Tristan Beau       http://www.apc.univ-paris7.fr/~beau/

AstroParticules et Cosmologie
11 pl. M. Berthelot, 75231 Paris cedex 05 tel: +33 1 44 27 14 46 , fax: +33 1 43 54 69 89 Received on Wed Feb 01 2006 - 17:40:45 MET