Re: How to have a table very very big?

2001-03-16 Thread Mario Latens
Thank you for your response (I said right?!? sorry for my little english!) what you say is very interesting!!! Where can I read more about RAID_TYPE ecc... (the 3 solution you said?)? Now I'm writing the program in C and I have not meet this problem but I will :-( Just for curiosity: I

Re: How to have a table very very big?

2001-03-16 Thread Roger Westin
Hi again, Theres not much written in the manual about RAID_X but you'll find it under CREATE TABLE Thank you for your response (I said right?!? sorry for my little english!) what you say is very interesting!!! Where can I read more about RAID_TYPE ecc... (the 3° solution you said?)? Now I'm

How to have a table very very big?

2001-03-15 Thread Mario Latens
I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that reading manual of Mysql). How to do a table so big? Thank you in advance, Rino.

Re: How to have a table very very big?

2001-03-15 Thread Roger Westin
Hi Mario, I think I had the same problem as you, and got som help... You have three ways of doing this: 1. Switch to a FileSystem that supports bigger Files 2. Use MERGE, create a lot of small tables and use MERGE in you select Querys, The manual is quit god at explaining how to do this, but

Re: How to have a table very very big?

2001-03-15 Thread Eric Fitzgerald
CTED] Sent: Thursday, March 15, 2001 12:49 AM Subject: How to have a table very very big? I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that read