one table with lots of records or more table with less records 
Author Message
 one table with lots of records or more table with less records
HI,

We're creating a big database, and I have a question. What do you all
think; you better have a big table with 1 billion records or 1000
tables with 1 million records?

Which one is easier to access and get the data?
And which one requires less database space?

Thanks in advance.
Bulent Gumus

Sent via Deja.com http://www.***.com/
Share what you know. Learn what you don't.



Tue, 20 Nov 2001 03:00:00 GMT
 one table with lots of records or more table with less records

How about:

One table with 1000 partitions?

Quote:

> HI,

> We're creating a big database, and I have a question. What do you all
> think; you better have a big table with 1 billion records or 1000
> tables with 1 million records?

> Which one is easier to access and get the data?
> And which one requires less database space?

> Thanks in advance.
> Bulent Gumus

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.



Tue, 20 Nov 2001 03:00:00 GMT
 one table with lots of records or more table with less records

If you are using Oracle8 my suggestion is to use one partitioned table.
Assuming an usual system, such as billing, you can define partitions for
each period.
Depending on the number of records, each period may be limited to year,
quarter or  month.

Using different physical disks to store tables and indexes also can be
helpful.
Machines with multiple processors can perform parallel query, with
improve the overall performance.

Regards

Quote:

> HI,

> We're creating a big database, and I have a question. What do you all
> think; you better have a big table with 1 billion records or 1000
> tables with 1 million records?

> Which one is easier to access and get the data?
> And which one requires less database space?

> Thanks in advance.
> Bulent Gumus

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

  brenogomes.vcf
< 1K Download


Thu, 22 Nov 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Lots records not being posted in table, identity_column shows missing records

2. Deleting Records In One Table Based on records in Another

3. Fetch record into a plsql table (record.column_1 into table(index_1))

4. Adding record in one table from form with two tables

5. Trigger to update one table when records are added to another table

6. Delete from one table with matching records in another table

7. Cannot add record to Visual Foxpro table after deleting all records in table

8. records transfer from one table to another table

9. adding records from a table in one server to a table in another server

10. 1 table for many records or many tables with few records

11. What's better: one large .4gi or lots of little ones

12. One big table or lots of smaller ones ?


 
Powered by phpBB® Forum Software