Open
Description
What happens?
I want to use duckdb to speed up the mysql query in mysql db,just like: select sum(amt) from mysqldb.order.order_info (3rows for test), the query prepare run 350 ms, and execute query with 400ms, I think it is too slow , compare with direct use mysql jdbc client ( run with 2ms), I expect the mysql extension can run less than 100ms in small data(less than 1000rows), and speed up 10x in bigdata（more than 100000 rows）,compare with mysql jdbc, how can I do for this?
To Reproduce
install mysql;
load mysql;
attack "......"
use mysqldb
select sum(amt) from mysqldb.order.order_info
OS:
mac
MySQL Version:
8.1
DuckDB Version:
0.10.1
DuckDB Client:
java
Full Name:
何俊然
Affiliation:
有信科技 youxin china
Have you tried this on the latest main branch?
- I agree
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
- I agree
Metadata
Metadata
Assignees
Labels
No labels