Re: jTDS driver

On 06.06.2005 13:17 JScoobyCed wrote:

> We do have also some DB design issue that we are correcting. This to
> prevent (N+1) queries when 1 query could be done. This is a part of the
> work.
> But I have been suggested another driver that is supposely faster. This
> is the question I have for you guys :) Is there a way/config that jTDS
> is better for or not?

The point is: if you have serious problems with your queries (missing indexes,
wrong where clause etc) then even a faster driver won't help you. The driver
will only speed up data transfer between the server and the client, but not the
processing *on* the server.

Taking your comments into account (without knowing the details though) I would
very much doubt that you will see a big difference. But then, why not simply
test it? Apart from changing the URL and driver class, there shouldn't be any
further changes to be made.

Thomas
.

Relevant Pages

  • Re: Reusing SQL data-related logic, replacing weird modules and improving Class::DBI
    ... > portable queries. ... parameters by a Driver object with automatic subclassing based on DBD ... locally ideosyncratic SQL string. ... typically only applies when you've asked the driver to generate queries ...
    (comp.lang.perl.modules)
  • Re: Can drivers lie?
    ... Queries to the driver: ... so it appears I am running OpenGL 1.3. ... A card might be 99% OpenGL 2.0 compliant and support ...
    (comp.graphics.api.opengl)
  • RE: getParameterMetaData bug?
    ... I'm getting stmt.getParameterMetaDataexceptions with simple queries like ... Query: SELECT program FROM ... Is your driver supposed to work with these simpler queries? ...
    (microsoft.public.sqlserver.jdbcdriver)
  • CONFIG_APM messages
    ... An odd problem just showed up in a VxD driver I wrote for a client's PCI ... When 98 goes into standby, it sends REMOVE queries rather ... than power queries, and it then unloads the driver. ...
    (microsoft.public.development.device.drivers)
  • How to conect ingres with Java in windows XP
    ... I want to use Java to perform queries in my ingres database. ... there is an ODBC driver installed in the server but I would like to use JDBC ... driver to connect directly with the database without using a JDBC/ODBC bridge. ...
    (comp.databases.ingres)
Loading