Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Distributing and using VERY large tables.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00539842
Message ID:
00539978
Views:
18
>>Hi Edmond,
>>
>>We deal with the similar problem here. We use Mailer's files which we receive monthly. Using Mailer software we prepare an extract into txt file, then I do some manipulations and create a VFP Streets table, which we lately use for Address Standardization and Zipping. We use data for NE states only (as I recall, we filtered 4 states: MA, CT, RI, NH) and it's about 5-6mln. records.
>>We decided to not do Owner Address standardization for non-NE owners, since the percent of non-NE owners is relatively small. Anyway, you can divide data by regions, or by State, name them correspondingly, say, MEStreets, AZStreets, etc.
>
>Nadya,
>
>I assume that you use Mailer's own export function to export the data to a txt file or do you know what data format that Mailer's+ keeps the national database in and do the exporting yourself?
>
>Ed
>
>Ed

No, I don't know the inner details of Mailer program, though I may try to figure this out. Yes, we use its own export function. I can tell, that this program is very memory consuming, e.g. when we run Mailer program, we can not run other applications on this machine.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform