|
程序运行到读数据库数据这一段代码时就无响应,几秒钟过后数据读完就好了,打开tables少一点就不会出现卡,附代码
void MyThread::run(){ n++; QSqlQuery query; query.setForwardOnly(true); query.exec("select * from beijing where date like '2014:05:26' and time like '10:33:%'"); query.seek(n-1); s1 =query.value(1).toString(); s2 =query.value(2).toString(); s3 =query.value(3).toString(); s4 =(tr("beijing")); a=query.value(tongdao).toDouble(); b=query.value(tongdao+1).toDouble(); c=a+b; s5=QString::number(c,'g',6); //qDebug()<<"beijing"; query.setForwardOnly(true); query.exec("select * from fuzhou where date like '2014:05:26' and time like '10:33:%'"); ····· query.exec("select * from shaoguan where date like '2014:05:26' and time like '10:33:%'");····· query.exec("select * from yangshan where date like '2014:05:26' and time like '10:33:%'");····· query.exec("select * from wenyuan where date like '2014:05:26' and time like '10:33:%'");········ query.exec("select * from wuhua where date like '2014:05:26' and time like '10:33:%'"); ········· query.exec("select * from fugang where date like '2014:05:26' and time like '10:33:%'");·········· query.exec("select * from zijin where date like '2014:05:26' and time like '10:33:%'");········ query.exec("select * from guangning where date like '2014:05:26' and time like '10:33:%'");
··········
query.exec("select * from raoping where date like '2014:05:26' and time like '10:33:%'");········· query.exec("select * from guangzhou where date like '2014:05:26' and time like '10:33:%'"); ·········· query.exec("select * from deqing where date like '2014:05:26' and time like '10:33:%'");··········· query.exec("select * from nanning where date like '2014:05:26' and time like '10:33:%'");········· query.exec("select * from enping where date like '2014:05:26' and time like '10:33:%'");········· query.exec("select * from maoming where date like '2014:05:26' and time like '10:33:%'");············ query.exec("select * from sanya where date like '2014:05:26' and time like '10:33:%'");··········· query.exec("select * from wuhan where date like '2014:05:26' and time like '10:33:%'");··········· query.exec("select * from xiamen where date like '2014:05:26' and time like '10:33:%'");·········程序实际上很简单就是打开不同的tables,把数据取出来就行了,为什么这么慢,还会导致程序无响应!我读数据开了一个多线程。
|
|