In message <4cb4ba4e$0$1641$742ec...@news.sonic.net>, John Nagle wrote:
> In general, if you find yourself making millions of > SQL database requests in a loop, you're doing it wrong. I’ve done this. Not millions, but certainly on the order of tens of thousands. > Big database loads are usually done by creating a text file > with the desired data, then using a LOAD DATA INFILE command. May not always be flexible enough. > This (in MySQL) is tens to hundreds of times faster than doing individual > INSERT or UPDATE commands. Why should that be? The database cannot read a text file any faster than I can. -- http://mail.python.org/mailman/listinfo/python-list
