General and Desktop

Well I was able to get a significant speed increase in a production build by doing a bunch of query optimization. I no longer query a nvchar(400), 26million times. Instead, I let the server filter the names, into a new table and then I query the new table for all the names and create a map in my program. Luckily the database has a unique ID for every name. This is how I expected I would have to do it if I was processing billions of rows. I guess I will need to stick with Linux if I do that. My processData() code is slower than it is on linux for some reason. SQLServer::loop() processed 26800000 messages in 227282 ms

@appas Thank you, you saved me)

Hi, Since it's a user forum, you are not very likely going to get an answer about that. In between, nothing forbids you to try and build the module with Qt 6 and integrate it into your application.

@GGG03 said in Problem with QPlainTextEdit: I found the problem. It was the font. I was using Terminal 9, and with Segou UI it is not laggy. LOL! Hopeless.

@MarcoChiesi79 Even though this ones quite old: Would you mind explaining how exactly to include the library and perform the new bitbake? This would help me and maybe others having your exact issue.

@l3u_ However, it would be encoded as =01, not =1 ;-)

@TheoSys What if this feature gets suggested? Although the only way that I found to do that is by using the bug report system. But then I suspect it would be shut down as "user can implement this themselves".

@Abderrahmene_Rayene Absolutely no harm saying so your way :) Preference only. Just make 100% sure the fromString()/toString() work the same way as each other with regard to local time vs universal time.

@Damian7546 said in Convert QByteArray to int: quint16 val = buf2.toHex().toInt(nullptr,10); No, since toInt() converts readable characters written as integers, not binary stuff - please read the documentation.

@ChrisW67 , @AndrzejB But don't come back to us if you find the download isn't working right now... ;-)

@SGaist thks, i mixed qquaternion with eigen library.

Hi and welcome to devnet, You should check that you actually got an editor. Did you consider using the edit method ? It would be simpler than trying to click on the table view.

@ytx-cash void amsSupport::loadRentalForms() { QSqlQuery sql; QString sqlStatement = "SELECT * FROM RENTALS ORDER BY `Order Number` DESC "; QTreeWidgetItem * child = nullptr; QStringList header, parentString, childList; QString previousClass=nullptr; int row = -1; ui->amsSupportTreeViewWidget->clear(); // Clear the widget if(sql.exec(sqlStatement)) { header << "Order Number" << "Order Date" << "Customer Name" << "Equipment" << "Serial Number" << "Stock Number" << "Sales Person" << "Store Location" << "Status" << "Remarks"; ui->amsSupportTreeViewWidget->setHeaderLabels(header); while(sql.next()) { QString className = sql.value(0).toString(); if(previousClass != className) { parentString << sql.value("Order Number").toString() << sql.value("Order Date").toString() << sql.value("Customer Name").toString(); QTreeWidgetItem *item = new QTreeWidgetItem(parentString); ui->amsSupportTreeViewWidget->addTopLevelItem(item); previousClass = className; parentString.clear(); row++; } childList << " -> "; childList << sql.value("Order Date").toString(); childList << sql.value("Customer Name").toString(); childList << sql.value("Equipment").toString(); childList << sql.value("Serial Number").toString(); childList << sql.value("Stock Number").toString(); childList << sql.value("Sales Person").toString(); childList << sql.value("Store Location").toString(); childList << sql.value("Status").toString(); childList << sql.value("Remarks").toString(); child = new QTreeWidgetItem(childList); child->setFlags(child->flags() | Qt::ItemIsUserCheckable); ui->amsSupportTreeViewWidget->topLevelItem(row)->addChild(child); childList.clear(); } } else { log_error(); } } What this does is pull my rental order numbers then adds them to the item based tree view widget one by one until the order number changes then starts a new row. Here is the outcome [image: 8d2c6ca2-d9d1-4923-9f5b-b70a911cbc9f.png] I'm sure by now there are better methods of doing this but this is what I did and its been working fine. Good luck!

@Perdrix Problem solved - there was a minimum size on the QDockWidget that was set. I adjusted that and all appears good now! Thanks, D

@JonB We got it! [image: b5646101-1b90-4d5e-80b2-664d539aa481.png] This part of code was a solution: tableModel->setRelation(6,QSqlRelation("instruments","InstrumentID","InstrumentDimension1, InstrumentDimension2, InstrumentDimension3")); Thank you very much! Have a great day :)