Results 1 to 2 of 2

Thread: "Cache" mysql table locally to sqlite ?? (good or bad idea?)

  1. #1
    Join Date
    Oct 2008
    Location
    Europe
    Posts
    37
    Thanks
    3
    Thanked 1 Time in 1 Post
    Qt products
    Qt4
    Platforms
    Windows

    Red face "Cache" mysql table locally to sqlite ?? (good or bad idea?)

    Hey all,

    On one of my applications i have a "big" table (several tens of thousands rows) that I download from a mysql server. Is it a good idea to copy this table and import it to a sqlite memory database on the local host ? (in order to save SQL querys going through the internet) Is there a better way? The application can query the table several times per second.


    Thanks.

  2. #2
    Join Date
    Jun 2007
    Location
    India
    Posts
    1,042
    Thanks
    8
    Thanked 133 Times in 128 Posts
    Qt products
    Qt3 Qt4 Qt/Embedded
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: "Cache" mysql table locally to sqlite ?? (good or bad idea?)

    several times per second? ... cache it..

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
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.