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

Thank you very much for reading my post. can you please explain me what is differences between 1 index for one column and one index for multiple columns ? In addition to what Ryan Bobko has already said about SELECT statements, I should point out that the existence of indexes on a table aff

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, Grégoire 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 DI

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 , sho

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 statem

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() ?? You can use the search box in the top-right of the Derby site to search the Derby documentation. http://db.apache.org/derby/index.html Putting 'current date' in

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

How i can get current Date in sql statemetn ?

Hi Thank you for reading my post. how i can get current date in derby SQL ? something like Date() ??

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: 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

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

Hi Thank you very much for reading my post. can you please explain me what is differences between 1 index for one column and one index for multiple columns ? in both performance view and technical differences. example : create index Index1 on SSiteRequest (BANNERBANNERID, WEBSITESWEBSITEID,

Re: Problems opening DB on HP Tandem

George, Kenneth V [NTK] wrote: I am not sure this went through back to the group, so here it is again for those who did not receive it. Any more assitance on this would be much appreciated. Thanks. From: George, Kenneth V [NTK] Sent: Thu 1/5/2006 3:19 PM To:

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 o

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)

Grégoire Dubois wrote: 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 ?

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, but

RE: Problems opening DB on HP Tandem

I am not sure this went through back to the group, so here it is again for those who did not receive it. Any more assitance on this would be much appreciated. Thanks. From: George, Kenneth V [NTK] Sent: Thu 1/5/2006 3:19 PM To: Derby Discussion; Derby Discuss

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: 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 : Grégoire 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

Re: Select records that are not locked?

Hi, > "Mike" == Mike Matrigali <[EMAIL PROTECTED]> wrote: Mike> Mike> Derby does not support that. I have heard it referred to as "read past" Mike> locking. I don't believe there is any SQL standard or JDBC standard Mike> description of such a mode. Mike> Mike> It tends to be useful for q