Results 1 to 1 of 1

Thread: How to increase the speed of insertion of data into table in SQLITE

  1. 4th December 2008, 05:48 #1
    sudheer168
    sudheer168 is offline Intermediate user
    Join Date
    Aug 2008
    Posts
    84
    Thanked 1 Time in 1 Post
    Qt products
    Qt3 Qt4
    Platforms
    Windows

    Default How to increase the speed of insertion of data into table in SQLITE

    Hi ,I am using QT4.4 and SQLITE for database.Here I need to insert a data of 44 items into 44 columns table for every 1millisec which I have read from RS232 port for every 1ms by using QTimer. Here I am executing the query for every 1ms to insert the data of 44 channels but this makes my program slow down .
    So please suggest me to solve this problem.
    Another thing is how to insert data which is in 2Dimensional Array(50*44) in one instance ie executing query once only.
    So please help and suggest me to solve these problems.

    With Regards,
    Sudheer.
    Last edited by sudheer168; 4th December 2008 at 11:05.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. What design for one SQLite table and multiple models ? Bug or design issue ?
    By tapioca in forum Qt Programming
    Replies: 3
    Last Post: 5th October 2008, 23:41
  2. Bulk insert into SQLite
    By munna in forum Qt Programming
    Replies: 6
    Last Post: 19th November 2007, 03:56

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
  •  

Forum Rules

Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.