Re: Oracle problems

Hi Rob,

The problem is not the opening it self. I can change the settings, the 
behaviour remains the same. I guess it has more to do with the query of the 
content resp. row-count. And I wonder, if they are executed in a thread. resp. 
if one Thread blocks another one (e.g. query of a SQL is hardly possible when 
the Row-Count is not finished yet, or the whole app crash, when I try to use 
the Content-assistent).

Since I know this problem, I can take care little bit. Nevertheless it is 
annoying that the Object-Pane interferes with the queries. Seems like no 
Threading resp. not very well designed Threading is there.

If it is for help of anybody, I can provide as well logs. IFF I know, how to 
get them and whom to send.

:)

LeO

Date: Tue, 12 Dec 2006 11:16:39 -0500
From: Rob Cope <rob@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Squirrel-sql-users] Oracle problems
To: squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
Message-ID: <84A3D5EB-1356-4DBA-B685-05A8200B4076@xxxxxxxxxxxxxxxxxxx>
Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed

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
-- 
"Ein Herz für Kinder" - Ihre Spende hilft! Aktion: www.deutschlandsegelt.de
Unser Dankeschön: Ihr Name auf dem Segel der 1. deutschen America's Cup-Yacht!

-------------------------------------------------------------------------
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