Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010

    Unanswered: Slow Inserts and Queries


    I have a program made in C running on a SCO Openserver 5 which reads from file registries and the checks the database 11 if the querie exist it updates it if it doesn't it inserts it.

    My problem is that in SCO the program takes about 3 hours, yet in solaris the same program takes about 5 hours, being solaris a better server when it come to resources.

    What i noticed is that aparently the queries seem slower in the solaris version.

    I would like to know if anyone has done something similar and can help me out to improve the performance since i need to migrate that process to the solaris server, but we can't afford doubling the times.

  2. #2
    Join Date
    Jul 2009
    There's a lot of things this might be. First, try the obvious...

    * "update statistics medium" for all databases.

    If this has no effect on performance, try running some of the sqls in dbaccess, with "set explain on;" beforehand - output goes to a file called sqexplain.out - and should hopefully give you hints as to which queries are slow (anything that is "SEQUENTIAL SCAN" is bad - might hint at a missing index).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts