write to a .txt log in some sort of standardized format , when it hits 10k lines run a batch query
as mentioned above, mysql has its own insert format; postgres does too. both insert formats are FAR faster than going through individual inserts. when i still used mysql about 4 years ago, i remember benching an insert of geographic data. it was something like 6 hours via inserts, 4hours via grouped inserts, and 25 seconds using the native import format. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
