Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

MS SQL Views

Thread Tools
 
Search this Thread
 
Old Jan 15, 2003 | 11:40 AM
  #1  
Mojo's Avatar
Mojo
Thread Starter
Scooby Regular
 
Joined: May 2000
Posts: 409
Likes: 0
Question

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
Reply
Old Jan 15, 2003 | 11:43 AM
  #2  
chiark's Avatar
chiark
Scooby Regular
 
Joined: Jun 2000
Posts: 13,735
Likes: 0
Post

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...
Reply
Old Jan 15, 2003 | 11:48 AM
  #3  
Mojo's Avatar
Mojo
Thread Starter
Scooby Regular
 
Joined: May 2000
Posts: 409
Likes: 0
Post

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
Reply
Old Jan 15, 2003 | 11:49 AM
  #4  
David_Wallis's Avatar
David_Wallis
Scooby Regular
 
Joined: Nov 2001
Posts: 15,239
Likes: 1
From: Leeds - It was 562.4bhp@28psi on Optimax, How much closer to 600 with race fuel and a bigger turbo?
Post

not a problem.

David
Reply
Old Jan 15, 2003 | 11:49 AM
  #5  
Mojo's Avatar
Mojo
Thread Starter
Scooby Regular
 
Joined: May 2000
Posts: 409
Likes: 0
Post

ta
Reply
Old Jan 15, 2003 | 11:51 AM
  #6  
chiark's Avatar
chiark
Scooby Regular
 
Joined: Jun 2000
Posts: 13,735
Likes: 0
Post

Just checked - it's absolutely not a problem whatsoever, as everyone else has said...
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
KAS35RSTI
Subaru
27
Nov 4, 2021 07:12 PM
Frizzle-Dee
Essex Subaru Owners Club
13
Mar 9, 2019 07:35 PM
Rbon91
ScoobyNet General
49
Nov 21, 2018 03:23 PM
Abx
Subaru
22
Jan 9, 2016 05:42 PM
south_scoob
ScoobyNet General
22
Oct 3, 2015 01:05 PM




All times are GMT +1. The time now is 01:35 PM.