Results 1 to 17 of 17

Thread: How to achieve fastest database insertion

Threaded View

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

    Default Re: How to achieve fastest database insertion

    You are receiving 12000 records in 1.0 second.
    You are inserting 12000 records in 0.8 seconds.
    Seems to me to me are keeping up just fine although I do wonder why your figure is 3 times longer than mine (Especially given your super-duper MySql backend vs my general MyISAM tables).

    Here are some more questions to answer for your own benefit:
    Where is the bottleneck? You still have not identified that. If you marshal the data into the query without actually executing it: how long does it take? What portion of the total time is this?
    Does this data need to be stored in an RDBMS at all?
    Is text the most efficient method of storing a date or time?
    Can data be aggregrated on-the-fly and only the aggregrate data stored?
    Can Lesiok's approach work for your application?
    "We can't solve problems by using the same kind of thinking we used when we created them." -- Einstein
    If you are posting code then please use [code] [/code] tags around it - makes addressing the problem easier.

  2. The following user says thank you to ChrisW67 for this useful post:

    karankumar1609 (20th November 2013)

Similar Threads

  1. How to achieve Alt+Tab effect ?
    By y.s.bisht in forum Newbie
    Replies: 0
    Last Post: 11th November 2011, 13:22
  2. How can i achieve an auto-resizing QStackedWidget?
    By truefusion in forum Qt Programming
    Replies: 2
    Last Post: 17th May 2010, 02:31
  3. How to achieve showAll ?
    By Gopala Krishna in forum Qt Programming
    Replies: 5
    Last Post: 5th October 2007, 14:26
  4. How to achieve Uniformity...!!!
    By deepusrp in forum Qt Programming
    Replies: 9
    Last Post: 7th May 2007, 09:11
  5. Insertion of unicode characters into database oracle through pro c
    By hemananda choudhuri in forum Qt Programming
    Replies: 1
    Last Post: 8th January 2007, 10:42

Tags for this Thread

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.