Re: TSQLServer & TMySQLServer

Hi Rene!

Yes, I understand that TSQLServer is a base class to TMySQLServer, TOracle... etc., but it's not an abstract base class, despite the fact that in http://root.cern.ch/root/html/TSQLServer.html it says so. So I have two choices to connect to a MySQL server: TSQLServer or TMySQLServer (we tested both, either worked).

Therefore I was wondering

 >> ..., if one (e.g. TMySQLServer) is preferred above the
 >> other (TSQLServer), e.g. for performance reasons or if they are
 >> completely equivalent to use.

They seemed equivalent when testing, but I was wondering about subtle or not so subtle differences?!

Thanks and cheers, Bernd.

Rene Brun wrote:
> Bernd,
>
> Note that TMySQLServer is just an incarnation of TSQLServer base class,
> like we have TOracleServer, etc.
>
> Rene
>
> On 30/09/2010 17:15, Bernd Reinhold wrote:

>> Dear ROOTers!
>>
>> With ROOT comes a class TSQLServer, TSQLResult, TSQLRow but there are 
>> also TMySQLServer, et al. Either can be used to connect to a mySQL 
>> server.
>>
>> Now I was wondering, if one (e.g. TMySQLServer) is preferred above the 
>> other (TSQLServer), e.g. for performance reasons or if they are 
>> completely equivalent to use.
>>
>> Thanks and cheers, Bernd.
>>