From: Patrick McGreevy
Tennessee - United States
To: Tyrone Matthews
Databases, Tables and SQL Server
Monday, December 29, 2008 1:41:48 AM
This message was rated by:
> Hey guys
> I got big load of data but i have to put it in two tables i want to put it in one does anyone know of anyfree SQL i herd MSDE has 4GB limit but anything up to date that has same sort of speck,
Me thinks that you should get used to breaking your tables up into a smaller size.
I have noticed it to be standard procedure for many of the apps I have to deal with. And this includes Oracle and SQL apps.
One Oracle database I pull data from, I have to pull from six different tables.
My own archive database I pull from, I split into two tables. One for the last year of data and the other for the previous two years. Anything over three years old in the second table, I write out to CD in the clear so it is easy to put this data into a third table and query it also.
The first two tables add up to around 7 million records, but come nowhere near the 2 G limit.
At the least, this can speed up your queries. You only have to access the tables which contain the data you are interested in, not one table. That's what makes relational databases so fun!
You need to normalize your database by splitting the data up into tables which handle a certain part of the whole picture. One Oracle database I access for information on part numbers has one of(50 tables?) which list only the part number and a primary key so you can access only the tables you need for your query by relating by the primary key. This database is changed monthly, so no need for a date entered block in the primary access table, but if you need that field, you can always add it.
Just my opinion. HTH
Posted by Tyrone Matthews @ 12/24/2008 11:00:44 AM
Posted by Anil Sharma @ 12/24/2008 11:13:31 AM
Posted by Anders Altberg @ 12/24/2008 12:53:07 PM
Posted by Bernard Bout @ 12/27/2008 7:17:48 AM
Posted by Cetin Basoz @ 12/24/2008 1:43:46 PM
Posted by Bernard Bout @ 12/27/2008 7:10:55 AM
Posted by Patrick McGreevy @ 12/29/2008 1:41:48 AM