php查询sqlite慢_sqlite数据查询速度慢的可能原因

1.返回数据库字段信息与要查询数据库的数据字段不一致：

如下例：返回的字段少个IMGURL

String where = String::format("%s='%s'", AppBean::APPID().string(), appid.string());

DbResolver* p = DbResolver::getInstance();

if (p != NULL) {

StringArray pro(2);

pro.replaceAt(AppBean::PACKAGENAME(), 0);

pro.replaceAt(AppBean::APPNAME(), 1);

AutoCursor cursor = p->query(AppBean::DOWNLOAD_TABLE_NAME(), pro, where, StringArray(0), "");

if (cursor->moveToFirst()) {

String pkg = cursor->getString(cursor->getColumnIndex(AppBean::PACKAGENAME()));

String appname = cursor->getString(cursor->getColumnIndex(AppBean::APPNAME()));

String imageUrl = cursor->getString(cursor->getColumnIndex(AppBean::IMGURL()));

Demand d = NotificationDelegate::createDemand(appname, pkg, imageUrl, "", NotificationDelegate::STATUS_WAITDOWNLOAD, NotificationDelegate::PARAM_CANCEL);

mpContext->invokeDelegate(&d);

}

}

正确方式应为：

String where = String::format("%s='%s'", AppBean::APPID().string(), appid.string());

DbResolver* p = DbResolver::getInstance();

if (p != NULL) {

StringArray pro(3);

pro.replaceAt(AppBean::PACKAGENAME(), 0);

pro.replaceAt(AppBean::APPNAME(), 1);

pro.replaceAt(AppBean::IMGURL(), 2);

AutoCursor cursor = p->query(AppBean::DOWNLOAD_TABLE_NAME(), pro, where, StringArray(0), "");

if (cursor->moveToFirst()) {

String pkg = cursor->getString(cursor->getColumnIndex(AppBean::PACKAGENAME()));

String appname = cursor->getString(cursor->getColumnIndex(AppBean::APPNAME()));

String imageUrl = cursor->getString(cursor->getColumnIndex(AppBean::IMGURL()));

Demand d = NotificationDelegate::createDemand(appname, pkg, imageUrl, "", NotificationDelegate::STATUS_WAITDOWNLOAD, NotificationDelegate::PARAM_CANCEL);

mpContext->invokeDelegate(&d);

}

}