Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Issues with complex queries and loading 10000+ tables

The application is great. I am accessing an SQL 2008 R2 database over 3G and wifi, works completely fine but I noticed some issues.

1. In case of a large database say, 10000+ tables. The application is not able to retrieve the tables but is able to perform a select query (Less complex)

2. In case of a complex select query which is involving 10 different tables with an alias name, between, joins - inner, left, where, convert(Datetime) conditions, the application hangs not even when we touch the screen, nothing happens.
In this situation I have to restart the application. Do let me know if there shall be a solution. Thanks in advance. ARM
1 person has
this problem