db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tiago R. Espinha (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3842) Convert "org.apache.derbyTesting.functionTests.tests.store.holdCursorExternalSortJDBC30.sql" to junit.
Date Sat, 28 Mar 2009 12:53:50 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12693432#action_12693432
] 

Tiago R. Espinha commented on DERBY-3842:
-----------------------------------------

Here's what I get from the statistics after having:
1) Set sortBufferMax to 5
2) Made a Select statement with Order By to 1 column, on  a table with roughly 6000 records
of assorted data.

Source result set:
	Sort ResultSet:
	Number of opens = 1
	Rows input = 6148
	Rows returned = 6148
	Eliminate duplicates = false
	In sorted order = false
	Sort information: 
		Number of rows input=6148
		Number of rows output=6148
		Sort type=internal
		constructor time (milliseconds) = 0
		open time (milliseconds) = 0
		next time (milliseconds) = 0
		close time (milliseconds) = 0
		optimizer estimated row count:         5232.00
		optimizer estimated cost:         1105.97

Now, sort type=internal? I would have thought that it would give me "external" since the sortBufferMax
is set to 5 and we have 6000 rows to sort, but nope. What can I possibly be doing wrong?

> Convert "org.apache.derbyTesting.functionTests.tests.store.holdCursorExternalSortJDBC30.sql"
to junit.
> ------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3842
>                 URL: https://issues.apache.org/jira/browse/DERBY-3842
>             Project: Derby
>          Issue Type: Test
>          Components: Test
>            Reporter: Junjie Peng
>            Assignee: Tiago R. Espinha
>         Attachments: derby-3842-1.patch, derby-3842-1.stat, derby-3842-tiago.patch
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message