MS SQL Views
15 January 2003, 11:40 AM
#1
Scooby Regular
Thread Starter
Join Date: May 2000
Posts: 409
Likes: 0
Received 0 Likes
on
0 Posts
I was just wondering if there is a record limit for SQL views?
I've created a view that currently has 51,000 rows and it will double within the year. Is that going to be OK?
Cheers
Mojo
I've created a view that currently has 51,000 rows and it will double within the year. Is that going to be OK?
Cheers
Mojo
15 January 2003, 11:43 AM
#2
Scooby Regular
Join Date: Jun 2000
Posts: 13,735
Likes: 0
Received 0 Likes
on
0 Posts
Given that we're using views on a database with millions of records that return millions of records within the view, I don't think you'll have any problems. I'll just check with our techies...
15 January 2003, 11:48 AM
#3
Scooby Regular
Thread Starter
Join Date: May 2000
Posts: 409
Likes: 0
Received 0 Likes
on
0 Posts
I don't think it'll be an issue either... I think it's all just a matter of disk space at the end of the day and the processing power of the server 
Any figures would be nice though
Any figures would be nice though
Thread
Thread Starter
Forum
Replies
Last Post