squirrel-sql-users

[Squirrel-sql-users] Issues With Oracle

[Nathan A. <na...@gl...>]

I am using Squirrel 2.2 to connect to a Oracle Apps DB(lots of 
objects).  After I login it takes about 10 minutes before Squirrel is 
functional.  At the bottom of the screen I see "Loading Tables... 
Loading stored procedures...".  This process is taking way too long.  Is 
there a way to only load the objects for the user who is loggin in?  It 
appears to be loading all objects in the DB.  Disabling Load 
Schemas/Catalogs into object tree has no effect.

Thanks,
Nathan

Re: [Squirrel-sql-users] Issues With Oracle

[Gerd W. <bir...@t-...>]

Hi Nathan,

I just committed some changes to CVS that may help solve your problem. For 
details see the latest change log entry about Oracle performance here:

http://squirrel-sql.cvs.sourceforge.net/*checkout*/squirrel-sql/sql12/doc/changes.txt


I would be very grateful if you could tell me if my changes solve your problem. 
If you don't have the chance to build SQuirreL from CVS you will have to wait 
till next weekends snapshot.

Please note that the Oracle Plugin is needed for my changes to take effect.

Thanks

Gerd

Nathan Aaron wrote:
> I am using Squirrel 2.2 to connect to a Oracle Apps DB(lots of 
> objects).  After I login it takes about 10 minutes before Squirrel is 
> functional.  At the bottom of the screen I see "Loading Tables... 
> Loading stored procedures...".  This process is taking way too long.  Is 
> there a way to only load the objects for the user who is loggin in?  It 
> appears to be loading all objects in the DB.  Disabling Load 
> Schemas/Catalogs into object tree has no effect.
> 
> Thanks,
> Nathan
> 
> 
> 
> -------------------------------------------------------
> All the advantages of Linux Managed Hosting--Without the Cost and Risk!
> Fully trained technicians. The highest number of Red Hat certifications in
> the hosting industry. Fanatical Support. Click to learn more
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>