Posted by Jerry Stuckle on 11/17/07 01:51

Mark Space wrote:
> Jerry Stuckle wrote:
>> Mark Space wrote:
>>> Jerry Stuckle wrote:
>>>
>>>> database and request were identical in both cases. This was using DB2.
>>>
>>> And yet, I was asking about your problems with JDBC with Linux and
>>> MySQL......
>>>
>>
>> I didn't specify Linux and MySQL.
>>
>
> OK, NC did. You just specified JDBC, which is assumed to be written
> largely in bytecodes.
>
> Should I be able to reproduce this on smaller tables? Say, less than 1
> million rows and less than 5 joins? Or does the problem only happen
> with larger DBs?
>

Makes no difference the number tables, size, etc. Once it gets to the
database (where all that work is done), the language is immaterial.

It does, however, depend on the number of rows actually retrived.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]