I have a Question about SQL 7.0 and the number of Records it can hold in one

Table. I Have not tested this, I quess I could loop a 1,000,000 records in

to the Table and see for my self but, What is going on is there is a table

that that the customer want to hold all data from all the forms from the

application in to it, Currently they are running FoxPro and three of the

Tables in FoxPro have 200,000+ records and total records in excess of

1,000,000, With about 1/4 of the records having feilds with Memo or 5000 chr

fields. Should I let them put it all in one table or should I put it in

multiple Tables. The application is a Contact management, Case management

system. If you have a link I am willing to read, thanks in advance



Tim Morford

From a storage standpoint, I have been made to understand that your

limitation should be the physical storage capacity of your server.  You 

may

want to take a look at the VBPJ from a couple months ago (sorry I can't

remember the month) on distributed partitioned views.  In essence, you 

can

have CustomerAM table and CustomerNZ table.  You set criteria on 

CustomerAM

table to only allow records where LastName starts with A-M and 

CustomerNZ

table to only allow records where LastName starts with N-Z.  You create 

View

Customer which selects all rows from both tables (using UNION).  This 

view

is used by developers as a table.  Because of the criteria set on the

tables, SQL Server knows where to append new records and which table to 

scan

on SELECT.  I've never used this feature, but it sounds like it could 

be a

great asset.



=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=3D=3D=3D=3D=3D=3D=3D=3D=3D

Kyle M. Burns, MCSD

ECommerce Technology Manager

Centra Credit Union

kburns@c...







-----Original Message-----

From: Tim Morford [mailto:tmorford@n...]

Sent: Thursday, August 23, 2001 11:31 AM

To: ASP Databases

Subject: [asp_databases] SQL 7.0 record number





I have a Question about SQL 7.0 and the number of Records it can hold 

in one

Table. I Have not tested this, I quess I could loop a 1,000,000 records 

in

to the Table and see for my self but, What is going on is there is a 

table

that that the customer want to hold all data from all the forms from 

the

application in to it, Currently they are running FoxPro and three of 

the

Tables in FoxPro have 200,000+ records and total records in excess of

1,000,000, With about 1/4 of the records having feilds with Memo or 

5000 chr

fields. Should I let them put it all in one table or should I put it in

multiple Tables. The application is a Contact management, Case 

management

system. If you have a link I am willing to read, thanks in advance



Tim Morford