re: re: Table-sizes, number of tables etc

2002-10-28 Thread Victoria Reznichenko
M, Monday, October 28, 2002, 2:55:44 PM, you wrote: >>Monday, October 28, 2002, 2:00:28 PM, you wrote: >> >>MS> At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: >> >>MdB> 2) How many entries can one single table have? MdB> (The absolute maximum) There are no limits on number of

re: Table-sizes, number of tables etc

2002-10-28 Thread M Spreij
>Monday, October 28, 2002, 2:00:28 PM, you wrote: > >MS> At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: > >>MdB> 2) How many entries can one single table have? >>>MdB> (The absolute maximum) >>> >>>There are no limits on number of rows. > >MS> What if the values for Primary Key run out? > >

re: re: Table-sizes, number of tables etc

2002-10-28 Thread Victoria Reznichenko
M, Monday, October 28, 2002, 2:00:28 PM, you wrote: MS> At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: >>MdB> 2) How many entries can one single table have? >>MdB> (The absolute maximum) >> >>There are no limits on number of rows. MS> What if the values for Primary Key run out? You get "

re: Table-sizes, number of tables etc

2002-10-28 Thread M Spreij
At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: >MdB> 2) How many entries can one single table have? >MdB> (The absolute maximum) > >There are no limits on number of rows. What if the values for Primary Key run out? Can you use a unsigned bigint as Primary Key? I mean, we /have/ to store

re: Table-sizes, number of tables etc

2002-10-28 Thread Victoria Reznichenko
Michelle, Saturday, October 26, 2002, 6:59:28 PM, you wrote: MdB> I am trying a "worst-case-scenario" of my databse. MdB> I have, so far, come up with some numbers to do the MdB> calculations with and perhaps a way of splitting one MdB> big table into smaller, yet structured, tables. MdB> (These

Table-sizes, number of tables etc

2002-10-26 Thread Michelle de Beer
I am trying a "worst-case-scenario" of my databse. I have, so far, come up with some numbers to do the calculations with and perhaps a way of splitting one big table into smaller, yet structured, tables. (These questions are not limited by hardware, because if the need for speed is there, the reve