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

Question

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

Answer 1

SQL="Select * From yourtable"

Answer 2

Join with me on Facebook

Answer 3

I use pyodbc to read data from MySQL

Answer 4

pyodbc is use for connection only

Answer 5

And when your make connection, then your are able read data.

Answer 6

By which way

Answer 7

Moment...

Answer 8

How to show data

Answer 9

How to load data fast way in QTableWidget or qtableview

Answer 10

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

Answer 11

Change IP adress to your server IP

Answer 12

I think you can't understand what i said

Answer 13

https://facebook.com/hackermaheshkumargupta

Answer 14

Join with me in Facebook

Answer 15

cursor=cn.cursor()

Answer 16

I will ask you there

Answer 17

I am an software development so i know this

Answer 18

I am finding another thing

Answer 19

I was sending your message on Facebook. I do not know qtablewidget