0

How to load fast way data from server in table using pyqt5 python

i have been used QTableWidget but it is so slow load large data from database

3rd Apr 2021, 7:50 AM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
19 Réponses
+ 1
SQL="Select * From yourtable"
3rd Apr 2021, 7:06 PM
Václav Dostál
Václav Dostál - avatar
+ 1
Join with me on Facebook
3rd Apr 2021, 7:23 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
0
I use pyodbc to read data from MySQL
3rd Apr 2021, 7:00 PM
Václav Dostál
Václav Dostál - avatar
0
pyodbc is use for connection only
3rd Apr 2021, 7:02 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
0
And when your make connection, then your are able read data.
3rd Apr 2021, 7:05 PM
Václav Dostál
Václav Dostál - avatar
0
By which way
3rd Apr 2021, 7:06 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
0
Moment...
3rd Apr 2021, 7:07 PM
Václav Dostál
Václav Dostál - avatar
0
How to show data
3rd Apr 2021, 7:07 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
0
How to load data fast way in QTableWidget or qtableview
3rd Apr 2021, 7:08 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
0
cn = pyodbc.connect('DRIVER={MySQL ODBC 3.51 Driver};'+'User ID=youuserID;Password=yourpassword; + 'Server=192.2.0.159;Database=myworkplan;'+ 'Port=3306;String Types=Unicode') # connect
3rd Apr 2021, 7:18 PM
Václav Dostál
Václav Dostál - avatar
0
Change IP adress to your server IP
3rd Apr 2021, 7:19 PM
Václav Dostál
Václav Dostál - avatar
0
I think you can't understand what i said
3rd Apr 2021, 7:20 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
3rd Apr 2021, 7:20 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
0
Join with me in Facebook
3rd Apr 2021, 7:21 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
0
cursor=cn.cursor()
3rd Apr 2021, 7:21 PM
Václav Dostál
Václav Dostál - avatar
0
I will ask you there
3rd Apr 2021, 7:21 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
0
I am an software development so i know this
3rd Apr 2021, 7:22 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
0
I am finding another thing
3rd Apr 2021, 7:22 PM
Mahesh Kumar Gupta
Mahesh Kumar Gupta - avatar
0
I was sending your message on Facebook. I do not know qtablewidget
3rd Apr 2021, 7:49 PM
Václav Dostál
Václav Dostál - avatar