Performance. Importend question

[ice-9]

Hi,

Im developing a project database. A normal project will need 10 000 records in the biggest table. Does this effect the performance? I mean, when they have done 8 projects, there will be like 80 000 records in one table. Is this to much? Does this influence the performance very much ?

The database is gooing to be placed on a sequelserver.

thanks for your reply since this is a very importend mather!!!

 

[Len Boorman]

My thoughts

80,000 records is not excessive in a table

SQL server will handle this quantity without a problem

Basically I suggest Performance issues are created by not correctly designing the database in the first place.

Normalisation, indexes, relationships are the things you should worry about when it comes to performance

L

 

[ice-9]

My thoughts

80,000 records is not excessive in a table

SQL server will handle this quantity without a problem

Basically I suggest Performance issues are created by not correctly designing the database in the first place.

Normalisation, indexes, relationships are the things you should worry about when it comes to performance

L

Ok, thanks for your reply.