hi everyone,

I am trying to extract data from a sqlite data base in embedded board.But it is taking 3 hours for 120510 records.My code is :

Qt Code: 
  1. QString str="select * from user20";
  2.     query_model.setQuery(str);
  3.  
  4.     i=0;
  5.     while(query_model.record(i).value("Id").toByteArray()!="")
  6.     {
  7.        data+=query_model.record(i).value("Id").toByteArray();
  8.        data=data+unit_sp;
  9.        data +=query_model.record(i).value("Name").toByteArray();
  10.        data=data+unit_sp;
  11.        data +=query_model.record(i).value("Address").toByteArray();
  12.        data +=record_sp;
  13.  
  14.        i++;
  15.     }
To copy to clipboard, switch view to plain text mode 


Is there any better way to extract or any thing extract is required ?