我们正在尝试解析一个文件并将其存储在MySQL数据库中。命令将导入一个可能达到几个GB大小的大型跟踪文件,因此用户可能有兴趣跟踪命令的进度。我们使用以下命令:
String commandText = "SET AUTOCOMMIT = 0; "
+ "START TRANSACTION; "
+ "LOAD DATA LOCAL INFILE \'" + filePath + "\' "
+ "INTO TABLE testdatabase.metadata "
+ @"FIELDS TERMINATED BY '\t' "
+ @"LINES TERMINATED BY '\n' "
+ "(Position,"
+ "Timespace,"
+ "Duration,"
+ "Disk,"
+ "Request,"
+ "Sector,"
+ "Length); "
+ "COMMIT;";
有没有办法在命令执行时跟踪进度以实现进度条?