|
From: LeO W. <le...@gm...> - 2006-12-15 11:31:09
|
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 <ro...@ec...> Subject: Re: [Squirrel-sql-users] Oracle problems To: squ...@li... Message-ID: <84A...@ec...> 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! |
