This thread was migrated from an old forum. It may contain information that are no longer valid. For further assistance, please post a new question or open a support ticket from the Customer Support portal.
Hi all,
Context : with the Windows8.1 app I'm maintaining users can full sync a database of 1Go (and more) after a resinstallation (while upgrading to a new version). I've found that during the time of the sync , let's say 1h20, only 20 minutes were spent for network/http calls between the app and the Kony Sync Server.
Question : is it possible configure another SQLite driver, let's say an ODBC driver (like in this web article http://web.synametrics.com/SQLite.htm), to try to better the performance of the SQLIte insert...?
Is the problem related to slow sync of records to your Device ?
Currently there is no feasibility to configure multiple drivers.
Can you please check if you have a feasibility to download data in batches like paged batching ?
What is the size of data you are downloading in one sync call ? if data is huge .Another option would be configuring multiple sync scopes and downloading data when required
The problem is related to slow sync and we want to try several ways to address this issue, one solution is to try to use an/another odbc driver to see if the performance are better.
The scenario we want to address is a full sync after the installation of the app (or new version), and currently we have users with 1 to 6 Go of data to sync (we already have mutliple sync scopes in the config).
I've already installed several odbc driver for SQLite on my machine but I did not found how to use them via the kony.db API.
Is there a way to specify the connection string while connecting to a SQLite database with kony.db API?
See for example : https://www.devart.com/odbc/sqlite/docs/index.html?database_encryption.htm
PS: I'll also investigate the "feasibility to download data in batches like paged batching".