June 19, 2003 at 11:51 am
Our customer table holds approx 5,000 records. Marketing would like to offer a free trial of our product which requires registration. They expect up to 250,000 registratnts. Is it best to seperate the data into two tables for performance or is 250,000 records still a small number for MS SQL Server 7.0 to handle. I would prefer to have a single table with a field id to seperate leads from customers.
June 19, 2003 at 12:14 pm
It is quite samll number. I have a table in size 70GB and over 73 Millions records.
June 20, 2003 at 4:09 am
Hi geocash,
quote:
Our customer table holds approx 5,000 records. Marketing would like to offer a free trial of our product which requires registration. They expect up to 250,000 registratnts. Is it best to seperate the data into two tables for performance or is 250,000 records still a small number for MS SQL Server 7.0 to handle. I would prefer to have a single table with a field id to seperate leads from customers.
it is a small number.
I would also prefer a single table, for not registrants are automatically customers (don't let marketing hear that!), but could easily be moves or transformed when buying your product
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 20, 2003 at 4:09 am
Hi geocash,
quote:
Our customer table holds approx 5,000 records. Marketing would like to offer a free trial of our product which requires registration. They expect up to 250,000 registratnts. Is it best to seperate the data into two tables for performance or is 250,000 records still a small number for MS SQL Server 7.0 to handle. I would prefer to have a single table with a field id to seperate leads from customers.
it is a small number.
I would also prefer a single table, for not registrants are automatically customers (don't let marketing hear that!), but could easily be moved or transformed when buying your product.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply