|
|
Posted by Brian on 06/16/58 11:17
Hi All
Trying to work out how many records a table can hold safely without causing
a problem.
I have one database with 7 tables, what I would like to know is how many
records each of these tables could hold
if they were all used
Can anybody let me know?
Table 1
id INT AUTO_INCREMENT PRIMARY KEY,
message
varchar(200),
username
varchar(30),
gender
varchar(30),
unit
varchar(50),
time
varchar(35),
numid int
Table 2
id INT AUTO_INCREMENT PRIMARY KEY,
number
varchar(20) NOT NULL,
unit
varchar(50),
username
varchar(30),
gender
varchar(30),
banned
varchar(8) DEFAULT 'false',
bannedreason
blob,
monday int(3),
tuesday
int(3),
wednesday
int(3),
thursday
int(3),
friday int(3),
saturday
int(3),
sunday int(3),
footy int(3),
timestamp
varchar(30)
Table 3
id INT AUTO_INCREMENT PRIMARY KEY,
unit
varchar(50) NOT NULL,
number
varchar(20) NOT NULL,
a int(3),
b int(3),
c int(3),
d int(3)
Table 4
id INT AUTO_INCREMENT PRIMARY KEY,
unit
varchar(30) NOT NULL,
msgcount
int(30) NOT NULL,
timestamp
varchar(30) NOT NULL
Table 5
id INT AUTO_INCREMENT PRIMARY KEY,
number
varchar(20) NOT NULL,
unit
varchar(50) NOT NULL,
timestamp
varchar(30) NOT NULL
Table 6
id INT AUTO_INCREMENT PRIMARY KEY,
unitname
varchar(30) NOT NULL,
timestamp
varchar(30) NOT NULL
Table 7
id INT AUTO_INCREMENT PRIMARY KEY,
unitname
varchar(30) NOT NULL,
message
varchar(200) NOT NULL,
timestamp
varchar(30) NOT NUL
Navigation:
[Reply to this message]
|