Posted by Bert Melis on 10/13/67 11:17

Brian wrote:
> 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
>
>

http://www.eweek.com/slideshow/0,3670,s=1590&a=23120&po=1&i=1,00.asp

• Next in forum: Re: Escaping/Unescaping - what's the best way to do it?
• Prev in forum: MySQL Capabilities
• Thread view: Re: MySQL Capabilities

[Reply to this message]