rust客户端延时很大,比其他客户端差了10倍数量级

[mmc-98]

1. 新建库

create database power;

2. 新建超级表

CREATE STABLE power.meters (ts TIMESTAMP, current FLOAT, voltage INT, phase FLOAT) TAGS (location BINARY(64), groupId INT)

3 插入表数据(rust)

use taos::*;
use tokio::time::Instant;

#[tokio::main]
async fn main() -> anyhow::Result<()> {
    let now = Instant::now();
    let dsn = "ws://192.168.0.253:6041";
    let taos = TaosBuilder::from_dsn(dsn)?.build().await?;

    let inserted = taos.exec("INSERT INTO
    power.d1001 USING power.meters TAGS('California.SanFrancisco', 2)
     VALUES (NOW, 10.30000, 219, 0.31000)").await?;

    // assert_eq!(inserted, 8);
    println!("===   rust 程序运行了 {:?} ms  ===",  now.elapsed().as_millis());

    Ok(())
}

4. 结果:
   === rust 程序运行了 220 ms ===

运行简单的一条sql插入要200ms, 但自测go-sdk和restful 方式插入20ms左右, 速度整整差了10倍.麻烦看下

[mmc-98]

3 插入表数据(go)

package main

import (
	"database/sql"
	"fmt"
	"log"
	"time"

	_ "github.com/taosdata/driver-go/v3/taosWS"
)

func main() {
	bT := time.Now()
	var taosDSN = "root:taosdata@ws(192.168.0.253:6041)/"
	db, err := sql.Open("taosWS", taosDSN)
	if err != nil {
		log.Fatalln("Failed to connect to " + taosDSN + ", ErrMessage: " + err.Error())
	}
	defer db.Close()

	insertQuery := "INSERT INTO " +
		"power.d1001 USING power.meters TAGS('California.SanFrancisco',2) " +
		"VALUES " +
		"(NOW, 10.30000, 219, 0.31000)"
	res, err := db.Exec(insertQuery)
	if err != nil {
		log.Fatalf("Failed to insert data to power.meters, sql: %s, ErrMessage: %s\n", insertQuery, err.Error())
	}
	rowsAffected, err := res.RowsAffected()
	if err != nil {
		log.Fatalf("Failed to get insert rowsAffected, sql: %s, ErrMessage: %s\n", insertQuery, err.Error())
	}
	// you can check affectedRows here
	fmt.Printf("Successfully inserted %d rows to power.meters.\n", rowsAffected)

	// 从开始到当前所消耗的时间
	fmt.Println("=== go 程序运行了 ===: ", time.Since(bT))
	// ANCHOR_END: select_data
}

4.结果
=== go 程序运行了 ===: 20.527167ms

[mmc-98]

3.插入表数据(restful)

time curl --location -uroot:taosdata 'http://192.168.0.253:6041/rest/sql' -d "INSERT INTO
    power.d1001 USING power.meters TAGS('California.SanFrancisco', 2)
     VALUES (NOW, 10.30000, 219, 0.31000)"

4. 结果
   === restful 程序运行了 ===: 38.527167ms

[mmc-98]

在同等硬件条件下,rust客户端延时很大,比其他客户端差了10倍数量级

[mmc-98]

@qevolg @sheyanjie-qq sh @zitsen zi 几位大大,有空能帮忙看看是我使用方式不对吗

[qevolg]

@qevolg @sheyanjie-qq sh @zitsen zi 几位大大,有空能帮忙看看是我使用方式不对吗

I'll take a look this weekend if I have time.