Red Gate forums :: View topic - Slow performance vs2012.1
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Connect
SQL Connect forum

Slow performance vs2012.1

Search in SQL Connect forum
Post new topic   Reply to topic
Jump to:  
Author Message
coffeehouse



Joined: 13 Feb 2013
Posts: 1

PostPosted: Wed Feb 13, 2013 3:43 am    Post subject: Slow performance vs2012.1 Reply with quote

Hello and thanks for the great tools!

I wanted to give some feedback and/or see if i am not alone in this.

I have a rather large db of 20k+ objects (tables, views, sp's, function's,schema's, etc..)

When i have this in my solution, scrolling the list of tables, views, proc's etc, its so slow that its not even worth scrolling. In fact the only way i can use it, is utilizing the search box in the solution explorer.

Is this whats expected? I didn't think the scrolling would be such drain and its not for the SQL Server Database Projects i have in the now.

Spec for my comp:
i5-2500k 3.3ghz
8gb ddr3 1600 ram
hard disk - sandisk ssd 240gb.
gigabyte motherboard.

Its a screamer and my large solutions load in about 15 secs, so the performance hit i seen was not expected, but maybe its something i did? or is this expected?

Thanks again!
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 922
Location: Red Gate Software

PostPosted: Mon Feb 18, 2013 12:40 pm    Post subject: Reply with quote

Hi Coffeehouse,

Thank you for your forum post and sorry for the late reply.

A support call has been created for you, call reference F0069618

Can you please locate the SQL Connect log files normally available in this folder, C:\Users\<user_name>\AppData\Local\Red Gate\Logs\SQL Connect 1, and send an e-mail to support@red-gate.com, include the above call reference number in the subject field of the e-mail and attach the log file or files to the e-mail message?

I have looked through previous support calls, thus far you appear to be the first user to reported this type of error.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
thomashess



Joined: 24 Mar 2014
Posts: 1

PostPosted: Mon Mar 24, 2014 12:11 pm    Post subject: Reply with quote

I am experiencing the exact same thing. Is there a solution for this?


Just installed SQL Connect to evaluate it, and I have around 1700 objects (tables + sprocs).

Scrolling is impossible. I can click somewhere in the scroll bar and it takes around 5-10 seconds for the list to move down around 10 items.

SQL Connect is totally useless unless this is resolved.

Running VS2013 with latest version of SQL Connect and SQL Source Control (downloaded from site today).

Best regards
Thomas

P.S. let me know if you want log files. I am also a bit taken back by the fact that a lot of log files of 50 MB each are generated. See timestamps here:

SQL Connect 1-2014_03_24_09_52_50_0.log
SQL Connect 1-2014_03_24_11_37_08_0.log
SQL Connect 1-2014_03_24_11_41_18_0.log

50 MB of logging in just 4 minutes? That's insane... I can't imagine how much space that will take up if I start using this correctly. Perhaps it is the writing of log files that is slowing everything down?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group