QTableWidget Sql Query 25.000 records

[aekilic]

Dear All

I have a big problem like this...

I have the following code for QTableWidget

treeStoklarStokBilgisi->clear();
 	treeStoklarStokBilgisi->setUpdatesEnabled( false );
	QSqlDatabase cachedb = QSqlDatabase::database("cachedb");
 
 
 
QSqlQuery anas("", cachedb);
 
		QString query;
		QString arananStokNo = lineStoklarParcaNo->text();
		QString arananAciklama = lineStoklarAciklama->text();
 		QString arananMakina = comboStoklarMakina->currentText();
 
	query = "SELECT stok.stokid, stokisim, parcano FROM stok LEFT JOIN  stokindex ON stokindex.stokid = stok.stokid WHERE stok.stokid IN (SELECT stokid FROM stokindex WHERE parcano like '" + arananStokNo + "%')";
	if (radioMakina->isChecked())
	{
		query += " AND stokid IN (SELECT makinaindex.stokid FROM makinaindex, makina WHERE makinaindex.makinaid=makina.makinaid AND makina.makina_isim ~*'" + arananMakina + "')";
	}
 
	anas.exec(query);
 
	while(anas.next())
	{	
		QTreeWidgetItem *i = new QTreeWidgetItem(treeStoklarStokBilgisi);
		QString aciklama;
		QString stokno;
 
		//aciklama = anas.value(1).toString(); 
		//stokno = anas.value(0).toString(); 
//		i->setStatusTip(0, stokno);
		i->setText(0, anas.value(2).toString());
		i->setText(1, anas.value(1).toString());
 		i->setText(2, anas.value(0).toString());
 
		QSqlQuery parnox;
		QSqlQuery parnox("", cachedb);
		parnox.exec("SELECT parcano FROM stokindex WHERE stokid=" + stokno + " ORDER BY sorulma DESC");
		int iR=1;
		while(parnox.next())
		{
			if(iR==1)
			{
				i->setStatusTip(0, parnox.value(0).toString());
				i->setText(0, parnox.value(0).toString());
				i->setText(1, aciklama);
 				i->setText(2, stokno);
 
				iR++;
			}
			else if(iR>1)
			{
				QTreeWidgetItem *alti = new QTreeWidgetItem(i);
				alti->setStatusTip(0, parnox.value(0).toString());
				alti->setText(0, parnox.value(0).toString());
				alti->setStatusTip(1, stokno);
 				alti->setText(2, stokno);
			}
		}
	}
treeStoklarStokBilgisi->setUpdatesEnabled( true );

treeStoklarStokBilgisi->clear();
 	treeStoklarStokBilgisi->setUpdatesEnabled( false );
	QSqlDatabase cachedb = QSqlDatabase::database("cachedb");



QSqlQuery anas("", cachedb);

		QString query;
		QString arananStokNo = lineStoklarParcaNo->text();
		QString arananAciklama = lineStoklarAciklama->text();
 		QString arananMakina = comboStoklarMakina->currentText();

	query = "SELECT stok.stokid, stokisim, parcano FROM stok LEFT JOIN  stokindex ON stokindex.stokid = stok.stokid WHERE stok.stokid IN (SELECT stokid FROM stokindex WHERE parcano like '" + arananStokNo + "%')";
	if (radioMakina->isChecked())
	{
		query += " AND stokid IN (SELECT makinaindex.stokid FROM makinaindex, makina WHERE makinaindex.makinaid=makina.makinaid AND makina.makina_isim ~*'" + arananMakina + "')";
	}

	anas.exec(query);

	while(anas.next())
	{	
		QTreeWidgetItem *i = new QTreeWidgetItem(treeStoklarStokBilgisi);
		QString aciklama;
		QString stokno;
			
		//aciklama = anas.value(1).toString(); 
		//stokno = anas.value(0).toString(); 
//		i->setStatusTip(0, stokno);
		i->setText(0, anas.value(2).toString());
		i->setText(1, anas.value(1).toString());
 		i->setText(2, anas.value(0).toString());

		QSqlQuery parnox;
		QSqlQuery parnox("", cachedb);
		parnox.exec("SELECT parcano FROM stokindex WHERE stokid=" + stokno + " ORDER BY sorulma DESC");
		int iR=1;
		while(parnox.next())
		{
			if(iR==1)
			{
				i->setStatusTip(0, parnox.value(0).toString());
				i->setText(0, parnox.value(0).toString());
				i->setText(1, aciklama);
 				i->setText(2, stokno);

				iR++;
			}
			else if(iR>1)
			{
				QTreeWidgetItem *alti = new QTreeWidgetItem(i);
				alti->setStatusTip(0, parnox.value(0).toString());
				alti->setText(0, parnox.value(0).toString());
				alti->setStatusTip(1, stokno);
 				alti->setText(2, stokno);
			}
		}
	}
treeStoklarStokBilgisi->setUpdatesEnabled( true );

To copy to clipboard, switch view to plain text mode 

But the problem is when I try to load the data It takes to much time for loading the tree...

Can anybody help me to solve this problem...

[patrik08]

Can you post constructor from cachedb?

[aekilic]

cachedb is a database that I copy from postgres to memory to sqlite...

If you need the codes I could sent