This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
When using the server explorer in VS I can view columns, tables etc with no problem, but with a drag/drop in the LS designer It hangs (and after +- 1 min) puts the table on the designer. When updating the DB with the changes I made in the designer it just hangs.. I cant use the LS designer at the moment, it's too slow :( I'm using LS 3.0 (2010-01-04)
|
|
|
Hmm, I'm not able to reproduce this here. I'm testing with the Oracle 11 VS client (11.1.0.7.20, though that shouldn't make a difference, as LightSpeed actually uses the Microsoft Oracle client for designer purposes) running in a virtual machine, and have tested against an Oracle XE database in another virtual machine and our main Oracle 9 database across the network, and in both cases adding tables is acceptably fast (update database takes 10-15 seconds for the network database, which is poor but still nowhere near as bad as your experience). It's possible that this is a scaling issue. How many tables do you have? Do you have multiple schemas / owners and if so do the other schemas contain very large numbers of tables? Looking at network and CPU activity, does LightSpeed appear to be making excessive numbers of queries to the database, or is it just sitting there doing nothing for a minute? Were you able to use this same database successfully with the 2.x version of the designer? |
|
|
The problem appears to be in the lightspeed designer, and not the Oracle client. The reason I say this is the following: When using the server explorer in CV2008 I can view the columns etc of a table instantly. after just having viewed that table and it's columns in the explorer, I drag it onto the designer (just 1 table) and I have to wait about 1 minute for it to appear. Yes the DB is large with many large schemas, but if I can use the Server explorer with no problems, then the designer should perform similarly. It's the first time I try Oracle, so I cant do a comparison. I'm contracting part time to an unbrella of IT firms, and they are impressed with LS in favour of LLBLGen (I'm pushing it) but it wont get used with this problem.. :(
|
|
|
Thanks for the additional info. It looks like we had a scaling issue with the number of foreign keys defined in the database. I can't be certain this was your issue but it's the only issue I've been able to identify or reproduce that would lead to the kind of slowdown you've been suffering. I've committed a candidate fix for this which will be in nightly builds dated 9 Jan 2010 and above, available from about 1430 GMT. In my tests this reduced the time to import tables or update the database from approximately 24 seconds to 2 seconds, and I believe it should have much better scaling characteristics as the database size increases. Please do give it a go and let us know whether it improves matters in your scenario -- if not we may have to do some more investigation... |
|