Re: MySql Limitations??

2006-06-01 Thread Duncan Hill
On Thursday 01 June 2006 03:05, Mathieu Bruneau wrote: > Harish TM a écrit : > > hi... > > I need to store something like a couple of million rows is a MySql > > table. Is that ok or do I have to split them up. I intend to index each > > of the columns that I will need to access so as to spee

Re: MySql Limitations??

2006-05-31 Thread Mathieu Bruneau
Harish TM a écrit : > hi... > I need to store something like a couple of million rows is a MySql > table. Is that ok or do I have to split them up. I intend to index each of > the columns that I will need to access so as to speed up access. Insertion > will be done only when there is very lit

RE: MySql Limitations??

2006-05-30 Thread Jay Blanchard
[snip] I need to store something like a couple of million rows is a MySql table. Is that ok or do I have to split them up. I intend to index each of the columns that I will need to access so as to speed up access. Insertion will be done only when there is very little or no load on the server

Re: MySql Limitations??

2006-05-30 Thread Harish TM
Hey guys... Thanks a lot... Guess I will stick with MySql then harish On 5/30/06, peter lovatt <[EMAIL PROTECTED]> wrote: Hi We have tables of 1.5M rows 25 fields, in heavy use with frequent inserts and updates on a P4 with 1GB of RAM. Performance is fine, and the table size is 400MB

Re: MySql Limitations??

2006-05-29 Thread peter lovatt
Hi We have tables of 1.5M rows 25 fields, in heavy use with frequent inserts and updates on a P4 with 1GB of RAM. Performance is fine, and the table size is 400MB, so you should not have any problems. Peter On 29/05/06, Chris W <[EMAIL PROTECTED]> wrote: Harish TM wrote: > hi... > I n

Re: MySql Limitations??

2006-05-29 Thread Chris W
Harish TM wrote: hi... I need to store something like a couple of million rows is a MySql table. Is that ok or do I have to split them up. I intend to index each of the columns that I will need to access so as to speed up access. Insertion will be done only when there is very little or

Re: mysql limitations

2003-02-08 Thread Michael T. Babcock
Martin Hudec wrote: I would like to know what are limitations for mysql in number of records, size of records, size of tables etc. Check the free online user-commented manual first, ask any questions you still have afterward. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibresp

Re: mysql limitations

2003-02-08 Thread Martin Hudec
Oh yes thank you Jerry this is what i was looking for. Hmmm as far as for maximum number of rows, it can be defined it seems by MAX_ROWS parameter while CREATE TABLE :). Thanks On Fri February 7 2003 14:38, Jerry wrote: > http://www.mysql.com/doc/en/Table_size.html > > More lightly to be file s

Re: mysql limitations

2003-02-08 Thread Jerry
http://www.mysql.com/doc/en/Table_size.html More lightly to be file system than dB I think depending on the version. Jerry Apps-R&D Cable and Wireless - Original Message - From: "Martin Hudec" <[EMAIL PROTECTED]> To: <[EMAIL PROTE

Re: mysql limitations

2003-02-08 Thread Cedric Gavage
Martin Hudec wrote: Hello, I would like to know what are limitations for mysql in number of records, size of records, size of tables etc. Can anyone help me please? You could see information about it on: http://www.mysql.com/doc/en/Features.html http://www.mysql.com/doc/en/Table_size.html --