Re: Reading blobs larger than a certain size fails with memory error

Thank you very much. It works ! Greg Le dimanche 08 janvier 2006 15:21 -0800, Daniel John Debrunner a crit : Grgoire Dubois wrote: Here is some sample code. Thanks for the repro. If you change the statement type to ResultSet.TYPE_FORWARD_ONLY from ResultSet.TYPE_SCROLL_INSENSITIVE

SELECT very slow when BLOB(2G)

Hi all, Here is the select I do on the following table. If file is a BLOB(2G), the request is very very slow (30-60s), even if there is only one line for the table. But if I replace BLOB(2G) by BLOB(5M) or BLOB(1G), the request becomes very fast. Is there a reason ? Is there a workaround ?

Re: Selecting first N rows of a result set

Bernt M. Johnsen wrote: Hi, Please post your SQL and JDBC code. That might make it possible to us to see whay you have performance problems. The SQL is very simple: SELECT * FROM system_log_view (although there may be optional search and ordering criteria as well, as specified by the user,

Re: Reading blobs larger than a certain size fails with memory error

Daniel John Debrunner wrote: So it's a bug, but there is a workaround. I have opened Jira entry - DERBY 802 for this. Thanks, Sunitha.

Re: SELECT very slow when BLOB(2G)

I don't read the blob in my request (the blob is db_file.file, and it isn't used in the select) : SELECT DISTINCT db_file.ID,db_file.name,db_file.reference,db_file.hash FROM db_file ORDER BY db_file.name; And the slowliness of the request isn't related to the data filled in the blob, it is

Re: What is performance differenc(es) between 1 index per column or one index for multiple column?

As with everything in databases, performance depends on what you're doing. (What follows is general database information, not Derby specific.) If you have a query like: select bannerbannerid from SSiteRequest where BANNERBANNERID=6 and WEBSITESWEBSITEID=10 and USERSUSERID=1 then the composite

RE: Problems opening DB on HP Tandem

Title: Re: Problems opening DB on HP Tandem Thanks for getting back to me. Yes, HP does indeed have a JVM at 1.4.2, but unfortunately we are not really close to upgrading yet - different department altogether...:( And yes, I did get the same error when trying to create the db. I will

Re: How i can get current Date in sql statemetn ?

Legolas Woodland wrote: Hi Thank you for reading my post. how i can get current date in derby SQL ? something like Date() ?? http://db.apache.org/derby/docs/10.1/ref/rrefsqlj34177.html thanks, bryan

Deby create LOCK on my table and do not release it , what is my mistake ?

Hi Thank you for reading my post. I have an update statement which i execute over a table in my database. now when i execute the update statement from my application (even after i exit the method that update the table) i can not use select statement over the same table. here is my update

When we run derby , in console window it show some connection numbers , what are them ?

Hi Thank you for reading my post. I defined a datasource and connection pooling in my web application. maximum size of pool is 32 , after some times that i deploy-undeploy the application in development environment , derby console windows show which after starting shows connection numbers ,

Re: SELECT very slow when BLOB(2G)

Ok, I must have a problem, as I seem to have the same problem with mysql. Thanks for your help. Best regards. Le lundi 09 janvier 2006 20:02 +0100, Grgoire Dubois a crit : I don't read the blob in my request (the blob is db_file.file, and it isn't used in the select) : SELECT