Re: Oracle problems

One thing that helps is to open the alias properties and set it to  
only load the schema(s) that you will use.  Also, it really helps to  
tell it not to load procedures.  Those can take a very long time to  
load.

Beyond that, doing a query that returns 100+ rows does seem to take a  
long time to load the data into the table.  I have not found a  
workaround for that.

Rob


On Dec 6, 2006, at 9:20 AM, LeO Welsch wrote:

> Hi,
>
> Squirrels seems to have problems with Oracle. I do not know how to  
> figure out, when it fails, but it fails definitely.
>
> The problem is, that from time to time I am unable to browse any  
> longer through the Objects nor can I open the right-hand side. The  
> content-assist is also broken, i.e. Tables are not offered any longer.
>
> I am not sure, when the problem start to get a problem, but  
> sometimes. I guess it has to do, that I want to click on the Table- 
> content, the content is not retrieved yet, click on the Row-Count,  
> this is also not retrieved yet, I click on the SQL-sheet and start  
> typing.
>
> Any ideas, if my guess is right?
>
> Is there a fix possible? I mean not on my nervous End-user side,  
> cause waiting approx. 200 secs. to get a result, before I can click  
> on the next Tab is a pain in the a** - As well I am aware the DB- 
> performance is lousy, and the approx. 400.000 entries should NOT be  
> THAT big problem for the View.
>
> :)
>
> LeO
>
> -- 
> Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
> Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
> <squirrel.log>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV________________________________ 
> _______________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV