Results 1 to 5 of 5

Thread: SQL Server data retrieving speed problem

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Nov 2010
    Posts
    10
    Thanks
    7
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: SQL Server data retrieving speed problem

    Thank you Joh,

    This is a valuable note for me, but my app still has speed problem. If you have any more suggestions please share with me!

    Aleksandar

  2. #2
    Join Date
    Feb 2007
    Location
    Karlsruhe, Germany
    Posts
    469
    Thanks
    17
    Thanked 90 Times in 88 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: SQL Server data retrieving speed problem

    Hi!

    I don't know if it will help, but you could try the following:

    1) retrieve the number of rows matching your query directly from mysql. => count ?
    2) append this number of rows to your text table at once
    3) fill the data.

    This way the texttable is only resized once. Maybe that increases the speed?

    Joh

  3. The following user says thank you to JohannesMunk for this useful post:

    Aleksandar (24th March 2011)

Similar Threads

  1. Debugger problem retrieving data for watch view hangs
    By frenk_castle in forum Installation and Deployment
    Replies: 0
    Last Post: 5th May 2010, 23:09
  2. Replies: 5
    Last Post: 21st March 2009, 09:10
  3. Replies: 0
    Last Post: 4th December 2008, 05:48
  4. Sql Server cannot retrieve data from select
    By Atomino in forum Qt Programming
    Replies: 10
    Last Post: 7th September 2006, 16:37

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.