blocks|key|4162285|text|好吧..。真的，既然你不能测量，你就只能猜测。你有没有安装过windows，进度条移动很慢，但突然它就跳了很多？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4162286|有几个想法。如果您只有一个SQL查询，那么您可以随着时间的推移慢慢移动进度条(比如每秒0.5%25？)。然后，如果查询在命中率达到90%25时还没有完成，则停止查询。然后，在它完成之前，不要让它结束。如果它提前完成(而缓慢的攀登正在进行中)，就跳到100%25。|4162287|另一个想法是多次运行查询来计算平均时间。使用它来做我在上一段中提到的相同的事情，但是使用平均时间，您可能可以使增量与实际进度更好地匹配。|4162288|祝好运!|4162289|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Well... really since you can't measure you just have to guess. You ever installed windows and the progress bar is very slow to move but then all of a sudden it jumps a great deal?

A couple ideas. If you have only one SQL query then you could slowly move the progress bar over time (like 0.5% per second?). Then if the the query hasn't finished by the time it hits 90% stop it. Then don't let it finish until it is done. If it finishes early (while the slow climb is going on) just jump to 100%.

Another idea is to run the query many times over to figure out an average time. Use this to do the same thing I mentioned in the last paragraph, but with the average time you can probably make the increments match better with the real progress.

Good luck!

blocks|key|2075771|text|这真的取决于如何架构你的代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2075772|据我所知，目前还没有用于跟踪任务进度的API，例如复制文件或运行SQL命令。如果您希望能够跟踪进度，则必须设计某种方法将任务分解为可度量的任务，然后将其用作进度基准。|2075773|例如，如果您正在执行一系列SQL+INSERT查询，请测量所需的查询数量(如果可能)。统计一下到目前为止您执行了多少次inserts。每次完成一个查询时，您都可以做一些简单的数学运算来测量您的进度，因为您已经获得了所需的总查询数和到目前为止的查询数。|offset|length|style|CODE|2075774|entityMap^0|0|0|H|6|1N|7|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@$F|O|G|P|H|I]|$F|Q|G|R|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|K|$]]

It really depends on how architect your code.

As far as I know, there is no API for tracking the progress of a task such as copying files or running SQL commands. If you want to be able to track progress, you'll have to devise some sort of way to break the task up into measurable tasks, then use that as your progress benchmark.

For example, if you were doing a series of SQL <code>INSERT</code> queries, measure the number of queries you will need (if possible). Keep a count of how many <code>inserts</code> you've performed so far. Every time you finish a query, you can do some simple math to measure your progress since you've got your total queries required, and your queries so far.

blocks|key|2084888|text|将进度条设置为选框，而不是进度。这将让您的用户知道仍在发生某些事情，而不提供确切的百分比。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2084889|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Set the progress bar to marquee instead of progress. This will let your users know that something is still happening without providing exact percentages.

How can I make a progress-bar in copy or SQL query or file transfer (rapi)?

Or some thing's that I can't measure?

Thanks for any help.

How to make a progress-bar in copy or query?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

如何在复制、SQL查询或文件传输(rapi)中设置进度条？或者是一些我无法测量的东西？谢谢你的帮助。

问如何在复制或查询中制作进度条？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在复制或查询中制作进度条？EN