SQL Complete Member List and big databases

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Yegoroff
Posts: 2
Joined: Tue 21 Dec 2010 09:52

SQL Complete Member List and big databases

Post by Yegoroff » Tue 21 Dec 2010 10:40

Hello,

We have a huge database containing approx 1000 tables and 1500 of other object types.
SQL Complete objects describe longs for a several minutes, that is not a reasonable time to provide smooth user experience. As a comparison I've test the SQL Assistant which do this in a several seconds.
Right now intellisense functionality is unavailable for the most of my queries, it would be great if you optimize SQL Complete performance to a reasonable times.
Top
.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Thu 23 Dec 2010 12:45

Thanks for the post.
We will prepare a separate server to emulate your situation.
Can you please specify the following:
1) the speed of the connection with the remote server
2) what are the timings of connection delays
3) average server loading
Top
Post Reply

Return to “dbForge for SQL Server”