Data base size discrepancy
in [General]
|
From: Susan L on 8 Apr 2010 14:01 I have two identical data bases; the same two tables, the same 28 fields per record, the same number (1675875) of records, the same queries and all the data is numerical (double). However, one data base is 530MB and the other is 1808MB! The second one takes much longer to load as well. I can find no reason for this. Can anyone suggest things I might take a look at?
From: Dorian on 8 Apr 2010 14:11 see other response -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Susan L" wrote: > I have two identical data bases; the same two tables, the same 28 fields per > record, the same number (1675875) of records, the same queries and all the > data is numerical (double). However, one data base is 530MB and the other is > 1808MB! The second one takes much longer to load as well. I can find no > reason for this. Can anyone suggest things I might take a look at?
From: Tom Hutchins on 8 Apr 2010 17:18 I thought the saying was, "Give a man a fish and he will eat for a day. Teach a man to fish and he will sit in a boat all day drinking beer." Hutch "Dorian" wrote: > see other response > -- Dorian > "Give someone a fish and they eat for a day; teach someone to fish and they > eat for a lifetime". > > > "Susan L" wrote: > > > I have two identical data bases; the same two tables, the same 28 fields per > > record, the same number (1675875) of records, the same queries and all the > > data is numerical (double). However, one data base is 530MB and the other is > > 1808MB! The second one takes much longer to load as well. I can find no > > reason for this. Can anyone suggest things I might take a look at?
From: Paul Shapiro on 8 Apr 2010 20:41
"Susan L" <SusanL(a)discussions.microsoft.com> wrote in message news:99369A0D-F3ED-42E8-9EC1-9E8F3EA682C2(a)microsoft.com... > I have two identical data bases; the same two tables, the same 28 fields > per > record, the same number (1675875) of records, the same queries and all the > data is numerical (double). However, one data base is 530MB and the other > is > 1808MB! The second one takes much longer to load as well. I can find no > reason for this. Can anyone suggest things I might take a look at? Try the Compact and Repair menu item. That's a poor name, because what it really does is reorganize the database and discard the trash that's been left in the file. If that doesn't help, create a new blank db and import everything from the old one. |