Slow Submit methods



  • Good day everybody ,
    I have a problem with using Submit methods it's work fine but very slow .
    For example if I making some changes in model with more than 50 000 rows it is about 30-40 sec.
    I know that some people have the same problem but they solve it by making decision not using classes such as QDataWidgetMapper .
    Is there a trick to using QSqlModel,QDataWidgetMapper and others with db such size without losing performance ?

    Sorry for my English ,it's not my native language and thank you for your time.



  • Hi, ~Dronissimo!

    Welcome to Qt Developer Network!

    To be honest - I don't know any tricks to manipulate with big databases. But if I need to solve your kind of problem I would do it on the low-level of course.



  • thank you for reply tucnak ,
    Yes ,I realize that if I would using databases such size I wouldn't use submit methods.
    You know I just think that 50 000 rows not to big for databases in our days =)


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.