Java RDBMS 性能
如果我在 Java 应用程序中有一个用于将数据插入 RDBMS 的方法，那么该方法在将查询传递到数据库后是否会继续前进。即，Java 应用程序将在 RDBMS 处理查询之前完成方法（连接、运行查询、关闭连接）。我想运行一些测试，但不确定应用程序是否会在 RDBMS 之前完成，因此无法了解数据库处理数据的速度？
我想我可以通过删除表关闭连接来完成每个测试，以确保应用程序必须等待 RDBMS 赶上。
使用 Eclipse IDE 在不同操作系统上测试 RDBMS 也会极大地影响其运行的操作系统的性能。 (Windows7 Solaris Ubuntu)
感谢任何尝试回答的人。
If I have a method in a Java application for inserting data in to a RDBMS does the method move forward once it has passed the query to the database. i.e will the java application finish the method(connect, run query, close connection) before the RDBMS has processed the query. I want to run some tests but was not sure if the application will finish before the RDBMS and as a result give very little insight into how quickly the database has processed the data?
I guess I could finish each test, with drop table close connection, to ensure that the application has had to wait for the RDBMS to catch up.
Also will using the Eclipse IDE to test RDBMS over different opperating systems affect the performance drastically of the O.S it is running on. (Windows7 Solaris Ubuntu)
Thanks to anyone who makes an attempt to answer.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
使用 IDE 不会影响性能 - 它只是启动一个常规 JVM。
至于另一个问题 - 除非你使用一些异步驱动程序（我不知道是否存在），或者为每个操作启动新线程，否则它们是同步的 - 即程序等待数据库返回结果（或超时） ，应该是可配置的）
Using an IDE won't affect performance - it's just a regular JVM that is started.
As for the other question - unless you are using some asynchronous driver (I don't know if such exist), or starting new threads for each operation, they are synchronous - i.e. the program waits for the database to return result (or to timeout, which should be configurable)
一般来说，所有此类调用都是同步的；它们会阻塞直到操作完成。除非你正在做一些非常不同的事情。
您可能需要研究连接池，以便可以重用连接以避免巨大的创建/销毁成本。
Generally, all such calls are synchronous; they block until the operation completes. Unless you are doing something very different.
You may want to look into connection pooling so that you can reuse the connections to avoid creation/destruction costs which can be substantial.