Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Distributing and using VERY large tables.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00539842
Message ID:
00539978
Vues:
14
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform