search

sqlite-sync / SQLite-sync.com

AMPLI-SYNC is a framework for synchronizing data between a Sqlite database and an MS SQL/MySQL/Oracle/PostgreSQL database. With this framework your application can work completely offline (Airplane Mode), then perform an automated Bidirectional Synchronization when an internet connection becomes available.
https://ampliapps.com/sqlite-sync/
BSD 3-Clause "New" or "Revised" License
328 stars 82 forks source link

Limit amount data to sync #8

Open CaballeroAlexis opened 5 years ago

CaballeroAlexis commented 5 years ago

Hi, i want to synchronize in two nodes a table with a amount of 400000 rows. When i try it, the system never come back the JSON because the size of the data to send. There is not problem when y synchronize less info. So, i want to know if there is a way to limit the amount of data of the JSON. The only table i want to sync have the next columns:

I use MySQL like a primary node and SQLiteSync 3.2.3

Thanks

tdziemidowicz commented 5 years ago

Do you need all 400 thousands rows on mobile? There is no simple way to split package of 400 thousands to smaller packages. You can limit amount of rows that are sent to device using filters. See https://docs.sqlite-sync.com/#filters

CaballeroAlexis commented 5 years ago

Yes, i need all the rows in all the devices so the filter cant help me. I try "create view FilterTest as select Node_id as pdaIdent, RowId from DBS_HISTORY LIMIT 100" but if the id of the device is not in the first 100 rows, then he didnt receive a data