Re: DBD::Sybase ping issue

2002-10-21 Thread Michael Peppler
On Mon, 2002-10-21 at 14:51, Henri Asseily wrote: > I suggest changing the DBD::Sybase ping statement which is totally > inefficient. > > Currently it's: > select * from sysusers where 1=2 > > I suggest the usual "select 1", which in my profiling averages 10x > faster than the above. Good idea.

DBD::Sybase ping issue

2002-10-21 Thread Henri Asseily
I suggest changing the DBD::Sybase ping statement which is totally inefficient. Currently it's: select * from sysusers where 1=2 I suggest the usual "select 1", which in my profiling averages 10x faster than the above. Would there be any reason to use the sysusers table except to check that it e