擅长:python、mysql、java
<p>代码解决方案和备注。</p>
<pre><code># Create empty list
dfl = []
# Create empty dataframe
dfs = pd.DataFrame()
# Start Chunking
for chunk in pd.read_sql(query, con=conct, ,chunksize=10000000):
# Start Appending Data Chunks from SQL Result set into List
dfl.append(chunk)
# Start appending data from list to dataframe
dfs = pd.concat(dfl, ignore_index=True)
</code></pre>
<p>然而,我的内存分析告诉我,即使在提取每个块后释放内存,列表也会越来越大,占用内存,导致可用内存的净净收益没有增加。</p>
<p>想听听作者/其他人的意见。</p>