Size limitations
Brian Donahue
Posts: 6,590 Bronze 1
Hi Andrew,
We get about 1MB/sec throughput on a 100Mbps switched network. Of course
there are so many variables, it's hard to say what the performance will be.
Odds are that the software is still responding, but your computer just
isn't up to the job of comparing all of that data. Data Compare can take up
lots of disk resources as well as processor power. We had just done a test
in house on a table with 150 columns and 8 million rows of data and it
didn't cause Data Compare to crash. It did take quite a while to complete,
though!
Regards,
Brian Donahue
Red Gate Technical Support
"Andrew Brogan" <noname@none.fuse.net> wrote in message
news:Ow56JocPEHA.3156@server53...
> Is there a row size limitiation for the SQL Data compare program? I
> have a table with 165 columns and 13.2 million rows of data. I am trying
to
> compare 2 of these tables and the program seems to lose itself and never
> come back. As a follow up, is there a chart or some metics on wait time
for
> table sizes? Thanks!
>
> -Andrew Brogan
>
>
We get about 1MB/sec throughput on a 100Mbps switched network. Of course
there are so many variables, it's hard to say what the performance will be.
Odds are that the software is still responding, but your computer just
isn't up to the job of comparing all of that data. Data Compare can take up
lots of disk resources as well as processor power. We had just done a test
in house on a table with 150 columns and 8 million rows of data and it
didn't cause Data Compare to crash. It did take quite a while to complete,
though!
Regards,
Brian Donahue
Red Gate Technical Support
"Andrew Brogan" <noname@none.fuse.net> wrote in message
news:Ow56JocPEHA.3156@server53...
> Is there a row size limitiation for the SQL Data compare program? I
> have a table with 165 columns and 13.2 million rows of data. I am trying
to
> compare 2 of these tables and the program seems to lose itself and never
> come back. As a follow up, is there a chart or some metics on wait time
for
> table sizes? Thanks!
>
> -Andrew Brogan
>
>
This discussion has been closed.
