Problem with large tables and row counts

Documents SQL Server 2000, 2005 and 2008 databases.


Moderators: David Atkinson, david connell, Charles Brown

Problem with large tables and row counts

Postby sshanny » Wed Jan 24, 2007 12:33 am

We are running SQL Doc 1.1 against a data warehouse that is about 6 TB in size. Some of the tables have 21 billion+ rows. It seems that you must be using an INT for storing that row count value and it is blowing out as those tables do not have any count values on them in the generated docs.

As a feature request, it would be nice to be able to turn off the fetching of row counts to shorten the processing time for generating the docs and reduce the load on the server.

Thanks.

--sean
sshanny
 
Posts: 8
Joined: Thu Dec 28, 2006 7:27 pm

Postby david connell » Wed Jan 24, 2007 12:39 pm

Hi Sean,
thanks for the comments. I will definately put it forward for a future release.
Thanks again
David
david connell
 
Posts: 167
Joined: Mon Nov 21, 2005 10:12 am


Return to SQL Doc 1

Who is online

Users browsing this forum: No registered users and 0 guests