Results 1 to 4 of 4

Thread: database slow

  1. #1
    Join Date
    Nov 2011
    Location
    coimbatore
    Posts
    80
    Qt products
    Qt4 Qt/Embedded
    Platforms
    Unix/X11
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default database slow

    hi, i have created qt database ...the driver is sqlite....i have maintain 100 students datas, whenever i retrieve this database the opening time going very slow ...what can i do

  2. #2
    Join Date
    Mar 2009
    Location
    Brisbane, Australia
    Posts
    7,729
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Thanks
    13
    Thanked 1,610 Times in 1,537 Posts
    Wiki edits
    17

    Default Re: database slow

    Work out where it is slow and fix it. We cannot see your code, your environment, your data... what do you expect us to do about it?

  3. #3
    Join Date
    Nov 2011
    Location
    coimbatore
    Posts
    80
    Qt products
    Qt4 Qt/Embedded
    Platforms
    Unix/X11
    Thanks
    1
    Thanked 5 Times in 5 Posts

    Default Re: database slow

    thank you for your reply....
    i found my problem....the problem is i have maintain my database in c++....i retrieve and viewing data from c++ to qml(screen) through QQuickView setcontextproperty ....so i retrieve as function through listview ....so this listview have for loop ......for i have maintain 100 students detais ...so this for loop running more time so only it is slow....please provide sollutions
    Last edited by ganeshgladish; 22nd June 2013 at 14:52.

  4. #4
    Join Date
    Jan 2006
    Location
    Graz, Austria
    Posts
    8,416
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Thanks
    37
    Thanked 1,544 Times in 1,494 Posts

    Default Re: database slow

    I am afraid I don't understand: the listview has a loop?

    Have you tried exporting your data through a model? Maybe using one of Qt's SQL models or QStandardItem model?

    Cheers,
    _

Similar Threads

  1. QSQLITE database changes not showing up in database
    By Cyrebo in forum Qt Programming
    Replies: 6
    Last Post: 15th April 2013, 00:18
  2. Replies: 2
    Last Post: 27th August 2012, 04:27
  3. Qt goes slow?
    By Cucus in forum Qt Programming
    Replies: 2
    Last Post: 20th July 2011, 05:43
  4. [SOLVED] database opened .. database not open
    By kapitanluffy in forum Qt Programming
    Replies: 1
    Last Post: 27th February 2011, 11:39
  5. Replies: 9
    Last Post: 20th May 2010, 10:55

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Qt is a trademark of The Qt Company.