Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Patrick McGreevy
  Where is Patrick McGreevy?
 Tennessee - United States
 Patrick McGreevy
 To: Tyrone Matthews
  Where is Tyrone Matthews?
 United Kingdom
 Tyrone Matthews
Subject: RE: Msde
Thread ID: 209110 Message ID: 209447 # Views: 1 # Ratings: 0
Version: Not Applicable Category: Databases, Tables and SQL Server
Date: Monday, December 29, 2008 1:41:48 AM         

> 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,
> cheers,
> Ty


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



Msde Posted by Tyrone Matthews @ 12/24/2008 11:00:44 AM
RE: Msde Posted by Anil Sharma @ 12/24/2008 11:13:31 AM
RE: Msde Posted by Anders Altberg @ 12/24/2008 12:53:07 PM
RE: Msde Posted by Bernard Bout @ 12/27/2008 7:17:48 AM
RE: Msde Posted by Cetin Basoz @ 12/24/2008 1:43:46 PM
RE: Msde Posted by Bernard Bout @ 12/27/2008 7:10:55 AM
RE: Msde Posted by Patrick McGreevy @ 12/29/2008 1:41:48 AM