file too large

[daN baueR]

I'd recommend deleting all the indexes before you try importing or deleting all those records. That will speed things up considerably. 

Dan

Sent using a personal electronic communications device.  Please excuse the brevity of this message and erratic spelling/typing. 


On Feb 3, 2011, at 5:00 PM, Jeff Harrison <jeffaharrison at yahoo.com> wrote:

> From: "scooter6 at gmail.com" <scooter6 at gmail.com>
>> 
>> To: Jeff Harrison <jeffaharrison at yahoo.com>
>> Cc: filePro Mailing List <filepro-list at lists.celestial.com>
>> Sent: Thu, February 3, 2011 4:45:39 PM
>> Subject: Re: file too large
>> 
>> 
>> Well, there are over 8 million records in this file - so I was looking for a 
>> bit quicker of a solution to get this resolved
>> I can't wait to get this system on a CentOS server - SCO is soooooo dang slow 
> 
>> haha
>> I'm currently looking to export the records to a few csv files, then delete 
>> key & data for this file and import only the most
>> recent 6 months or so and then resolve the rest when I get back next week from 
>> 
>> vacation....
>> Why do these things happen the day before I'm leaving town? haha
>> 
>> So, to clarify - is this a SCO OpenServer 5.0.5 issue, or is this a filePro 
>> error? Meaning, if I upgrade tonight to 5.6.10 would this
>> resolve the issue?
>> 
>> 
> 
> This is an OS limitation - I believe there is a way to expand the limit in the 
> OS - perhaps a Unix Guru will speak up?
> 
> Not sure why you would need to resort to CSV files import/export - just archive 
> the recent 6 months that you need to a file with a duplicate map, then rename 
> your original key and data to hldkey hlddata or something like that, and then in 
> the OS copy the key/data with the recent only info back to the original 
> location.  And then rebuild your indexes.
> 
> If you want it to go faster, you can remove the "delete" when you archive - just 
> remember that you will need to go back and remove those records later.
> 
> Jeff Harrison
> jeffaharrison at yahoo.com
> Author of JHImport and JHExport
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list