#620 VERY slow startup

open
Colin Bell
Core (461)
5
2012-12-29
2008-03-13
Anonymous
No

After using squirrel for migrating a DB from Oracle to Postgres the startup time is now about 20minutes on a P4/3.0GHZ System with 2Gbyte of Ram. Because of the long startup times i tried to reinstall it, but with no effects. I installed it on another maschine (same specs), and after some time the same effect took place. The startup process is very slow. I searched for files which maybe have gotten big during the migration task and didn´t found anything.
I also tried tuning the xm* parameters inside the startup batch file, and also no effects.

Discussion

  • Rodolfo Leyes
    Rodolfo Leyes
    2008-06-26

    Logged In: YES
    user_id=2128915
    Originator: NO

    I have noticed something strange about a very slow startup, I have installed squirrelsql on a Solaris10 and works just fine when I run the .sh script on my console in the directory where the script is by executing ./squirrel-sql.sh, but when I switch to another directory lets say / then if I issue the command using the absolute Path! /opt/tools/squirrel_sql_client/squirrel-sql.sh the startup time takes at least 5 or 6 times longer!

     
  • Rob Manning
    Rob Manning
    2008-11-27

    I've noticed when the user's home directory is on a mapped network drive, that startup and shutdown performance can be great affected.

    Rob