| --- Moved the sort into the initial file clean up on the Unix side of things. Had to split the zone file into 5 different files of around 20 million records a piece 'cause I was exceeding disk quota in my tmp directory due to the sort... then I merge them all back together, resorting the entire file and bulkload it into the database. Thus removing the need for the ORDER BY in the query code. That was the culprit for the lengthy queries... Even crazy wide open queries are coming back in a reasonable amount of time... So I bumped up the max return records to 250,000. That's mainly due to the limitation of the Flex Datagrid. |