[閒聊] 為什麼java的使用率比較高?
看板Soft_Job (軟體人)作者sunlights (sunlights)時間10年前 (2015/12/17 17:31)推噓25(25推 0噓 56→)留言81則, 41人參與討論串1/8 (看更多)
這是我在win7平台
iis+php7
iis+asp.net(C# .net4)
java(1.8)+tomcat
跑出來的
loop test (10000000)
php
0.25
java
0.013
.net
0.015
database test
select 13446 data use mysql
php
0.018
java
0.052
.net
0.028
loop select 21 times use mysql
php
0.01
java
0.143
.net
0.01
select 13446 data use oracle
php
0.039
java
2.036
.net
0.029
loop select 21 times use oracle
php
0.029
java
0.335
.net
0.037
select 13446 data use mssql(express)
php
0.053
java
6.26
.net
0.034
loop select 21 times use mssql(express)
php
0.05
java
129.451
.net
0.133
看起來C#的效能是最優的..為什麼
java的使用率仍是超越.net的呢?
http://tinyurl.com/qyos7vg
--
※ 文章網址: https://www.ptt.cc/bbs/Soft_Job/M.1450344689.A.ABE.html
→
12/17 17:34, , 1F
12/17 17:34, 1F
推
12/17 17:35, , 2F
12/17 17:35, 2F
→
12/17 17:35, , 3F
12/17 17:35, 3F
推
12/17 17:37, , 4F
12/17 17:37, 4F
→
12/17 17:42, , 5F
12/17 17:42, 5F
補上版本
推
12/17 17:49, , 6F
12/17 17:49, 6F
推
12/17 17:49, , 7F
12/17 17:49, 7F
→
12/17 17:58, , 8F
12/17 17:58, 8F
推
12/17 18:01, , 9F
12/17 18:01, 9F
推
12/17 18:19, , 10F
12/17 18:19, 10F
推
12/17 18:24, , 11F
12/17 18:24, 11F
→
12/17 18:48, , 12F
12/17 18:48, 12F
→
12/17 18:50, , 13F
12/17 18:50, 13F
→
12/17 18:51, , 14F
12/17 18:51, 14F
推
12/17 19:00, , 15F
12/17 19:00, 15F
推
12/17 19:02, , 16F
12/17 19:02, 16F
→
12/17 19:02, , 17F
12/17 19:02, 17F
→
12/17 19:04, , 18F
12/17 19:04, 18F
推
12/17 19:20, , 19F
12/17 19:20, 19F
→
12/17 19:20, , 20F
12/17 19:20, 20F
→
12/17 19:20, , 21F
12/17 19:20, 21F
→
12/17 19:21, , 22F
12/17 19:21, 22F
→
12/17 19:30, , 23F
12/17 19:30, 23F
推
12/17 19:30, , 24F
12/17 19:30, 24F
→
12/17 19:31, , 25F
12/17 19:31, 25F
→
12/17 20:00, , 26F
12/17 20:00, 26F
推
12/17 20:01, , 27F
12/17 20:01, 27F
→
12/17 20:02, , 28F
12/17 20:02, 28F
→
12/17 20:03, , 29F
12/17 20:03, 29F
推
12/17 20:08, , 30F
12/17 20:08, 30F
→
12/17 20:27, , 31F
12/17 20:27, 31F
→
12/17 20:40, , 32F
12/17 20:40, 32F
→
12/17 20:41, , 33F
12/17 20:41, 33F
→
12/17 20:50, , 34F
12/17 20:50, 34F
→
12/17 21:02, , 35F
12/17 21:02, 35F
→
12/17 21:03, , 36F
12/17 21:03, 36F
→
12/17 21:05, , 37F
12/17 21:05, 37F
→
12/17 21:23, , 38F
12/17 21:23, 38F
推
12/17 21:37, , 39F
12/17 21:37, 39F
推
12/17 21:39, , 40F
12/17 21:39, 40F
→
12/17 21:40, , 41F
12/17 21:40, 41F
推
12/17 21:59, , 42F
12/17 21:59, 42F
→
12/17 22:35, , 43F
12/17 22:35, 43F
推
12/17 22:46, , 44F
12/17 22:46, 44F
→
12/17 22:54, , 45F
12/17 22:54, 45F
→
12/17 22:58, , 46F
12/17 22:58, 46F
推
12/17 23:24, , 47F
12/17 23:24, 47F
連資料庫我是用下面的這種碼連
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@XXX.XXX.XXX.XXX:1521:SID","USER", "PASSWORD");
不知道有何錯誤??
※ 編輯: sunlights (111.240.99.172), 12/17/2015 23:33:13
→
12/17 23:35, , 48F
12/17 23:35, 48F
那請寫出自己的測試數據啊..畢竟我都有測出來了..
有人連連線都有困難..
※ 編輯: sunlights (111.240.99.172), 12/17/2015 23:38:00
→
12/17 23:37, , 49F
12/17 23:37, 49F
→
12/17 23:40, , 50F
12/17 23:40, 50F
→
12/17 23:43, , 51F
12/17 23:43, 51F
→
12/17 23:47, , 52F
12/17 23:47, 52F
→
12/17 23:51, , 53F
12/17 23:51, 53F
推
12/17 23:52, , 54F
12/17 23:52, 54F
→
12/18 00:01, , 55F
12/18 00:01, 55F
→
12/18 00:16, , 56F
12/18 00:16, 56F
→
12/18 00:17, , 57F
12/18 00:17, 57F
→
12/18 00:25, , 58F
12/18 00:25, 58F
→
12/18 00:26, , 59F
12/18 00:26, 59F
推
12/18 01:04, , 60F
12/18 01:04, 60F
→
12/18 01:20, , 61F
12/18 01:20, 61F
→
12/18 01:21, , 62F
12/18 01:21, 62F
→
12/18 01:43, , 63F
12/18 01:43, 63F
→
12/18 01:51, , 64F
12/18 01:51, 64F
→
12/18 06:16, , 65F
12/18 06:16, 65F
→
12/18 07:32, , 66F
12/18 07:32, 66F
→
12/18 10:00, , 67F
12/18 10:00, 67F
推
12/18 10:18, , 68F
12/18 10:18, 68F
→
12/18 10:38, , 69F
12/18 10:38, 69F
→
12/18 10:39, , 70F
12/18 10:39, 70F
→
12/18 10:39, , 71F
12/18 10:39, 71F
推
12/18 11:40, , 72F
12/18 11:40, 72F
→
12/18 11:49, , 73F
12/18 11:49, 73F
→
12/18 11:55, , 74F
12/18 11:55, 74F
→
12/18 12:31, , 75F
12/18 12:31, 75F
→
12/18 12:55, , 76F
12/18 12:55, 76F
→
12/18 12:57, , 77F
12/18 12:57, 77F
我用hikariCP
import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
HikariConfig config = new HikariConfig();
config.setMaximumPoolSize(100);
config.setDataSourceClassName("com.mysql.jdbc.Driver");
config.addDataSourceProperty("serverName", "localhost");
config.addDataSourceProperty("port", "3306");
config.addDataSourceProperty("databaseName", "aaa");
config.addDataSourceProperty("user", "root");
config.addDataSourceProperty("password", "bbb");
HikariDataSource ds = new HikariDataSource(config);
conn = ds.getConnection();
stmt = conn.createStatement();
sql="select * from tabl";
rs = stmt.executeQuery(sql);
while(rs.next()){
........
}
但是一直連不上..
ps:該下載的都有下載..
※ 編輯: sunlights (118.163.80.109), 12/18/2015 15:43:14
→
12/18 18:26, , 78F
12/18 18:26, 78F
推
12/19 21:33, , 79F
12/19 21:33, 79F
推
12/21 17:27, , 80F
12/21 17:27, 80F
推
12/21 18:29, , 81F
12/21 18:29, 81F
討論串 (同標題文章)
Soft_Job 近期熱門文章
PTT職涯區 即時熱門文章