how to make query faster? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

how to make query faster?

how to make query faster?# Database - 数据库

c*e2007-07-02 07:07

1 楼

I am doing some sql queries which need to join several tables in a
relatively large MySql database(version 4.**).
I've optimized the WHERE clause but the speed of the query is very slow...
Is it going to be faster if I write some API instead of doing direct query?
Please give me some suggestions!Thanks!

w*e2007-07-02 07:07

2 楼

what kind join you used?

【在 c********e 的大作中提到】

: I am doing some sql queries which need to join several tables in a
: relatively large MySql database(version 4.**).
: I've optimized the WHERE clause but the speed of the query is very slow...
: Is it going to be faster if I write some API instead of doing direct query?
: Please give me some suggestions!Thanks!

c*e2007-07-02 07:07

3 楼

thanks!I find out the problem.
The slow speed is because of I opened too many db connections...