Chat2DB icon indicating copy to clipboard operation
Chat2DB copied to clipboard

Published 20 hours ago • verified publisher icon CodePhiliaX

Bug: Slow export of data

Open lj1018913123 opened this issue 1 year ago • 4 comments

Chat2DB Version

3.1.17

Describe the bug

After querying the data, click Export csv. It will take 10-30 minutes for the file window to pop up.

lj1018913123 avatar Feb 19 '24 09:02 lj1018913123

Hello, could you please provide us with the database type you use, the table structure and the size of the data you exported?

openai0229 avatar Feb 20 '24 06:02 openai0229

Oracle database, exported about 17 pieces of data, count the data

lj1018913123 avatar Feb 20 '24 06:02 lj1018913123

Oracle database, exported about 17 pieces of data, count the data 刘健 @.*** … ---- 回复的原邮件 @.>发送日期2024年2月20日 @.>@.>@.>主题Re: [chat2db/Chat2DB] Bug: 导出数据缓慢 (Issue #1172)你好，请问可以提供一下你使用的数据库类型，表结构还有你导出的数据大小吗？—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

When I tested the export of 1,000 pieces of data, it was exported in seconds. Can you describe the problem in more detail? If possible, give the table structure and sql statement

openai0229 avatar Feb 22 '24 06:02 openai0229

Sorry, the table structure is not convenient to provide. It is the company's internal data. I guess it is caused by this. Network problem, because I need to log in to Fort VPN to connect to the database. The network speed is very slow, and exporting is required. Check the data again and export it?

lj1018913123 avatar Feb 23 '24 02:02 lj1018913123