Roy Tang

All entries tagged performance.

You can subscribe to an RSS feed of this list.

Oct 2010

• Reply to 'Python execution speed: laptop vs desktop' on stackoverflow:

  Split your processing into multiple threads. Your particular i7 should be able to support up to 8 threads in parallel.

  Posted by Roy Tang under notes at 15 Oct 2010 6:27am #python #performance #intel
  Also on: stackexchange / 0

Mar 2010

• Reply to 'comparing two cursors in oracle instead of using MINUS' on stackoverflow:

  MINUS is the same as saying “get all the rows of the first query, then from that set remove the rows that are also in the second query”, so you could like load the results from the first query into an array in-memory, then loop through the second query results and check them one-by-one against the first query results and remove them if they exist.

  I’m not sure that will actually perform better though (depends on a lot of things). You might also want to consider using NOT EXISTS instead and check that performance, i.e.

  SELECT  RTRIM(LTRIM(A.HEAD)),
    A.EFFECTIVE_DATE,
  FROM   TABLE_1 A
  WHERE  A.TYPE_OF_ACTION='6'
  AND    A.EFFECTIVE_DATE >= ADD_MONTHS(SYSDATE,-15)  
  AND NOT EXISTS (
    SELECT 1 fFROM TABLE_2 B
    WHERE RTRIM(LTRIM(A.HEAD)) = RTRIM(LTRIM(B.HEAD))
    AND A.EFFECTIVE_DATE = B.EFFECTIVE_DATE
  )
  

  Some functional indexing may also be needed on RTRIM(LTRIM(A.HEAD))

  Posted by Roy Tang under notes at 22 Mar 2010 11:12pm #performance #oracle
  Also on: stackexchange / 0