Android Question CloudKVS & physical data deletion

[luke2012]

Hi All,
I'm implemented a customer project using CloudKVS from @Erel. I keep all the original CloudKVS API and implemented custom business logic on top of the standard APIs.

The problem is that for my specific case (on top implementation), the Clients KVS has a performance problems when there are many records within the database.

I found a solution: using SQLite Expert I (physically) delete all the orders items and it works fine (customer doesn't need to keep them).

But this solution is not optimal because I have to do it manually each 1 or 2 months and connect to the CloudKVS Server of the customer to replace the main db.

Is there an alternative solution that I don't known ?

Thanks in advance
Luca.

 

[Erel]

Are you deleting old records from the client side, by putting Null values?

 

[luke2012]

Are you deleting old records from the client side, by putting Null values?

Yes I'm deleting putting null values.

 

[Erel]

Where exactly is the performance problem? When a new device connects to the server for the first time?

sing SQLite Expert I (physically) delete all the orders items and it works fine (customer doesn't need to keep them).

Are you deleting the server database? What about the clients?

 

[luke2012]

To make it works fine I do this (periodically):

1) On server db: I run a sql delete on all "orders" records
2) I ask to the customer to remove and re-install the apps (CloudKVS Clients)

And all work fine. But this is not a very elegant solution to do periodically and manually.

 

[Erel]

Untested suggestion:
Delete old records from the client when the app starts:

sql.ExecNonQuery2("DELETE FROM data WHERE time < ?", Array(DateTime.Now - 7 * DateTime.TicksPerDay))

You can do a similar thing when the server starts or better every day using a timer in DB module.

 

[luke2012]

Untested suggestion:
Delete old records from the client when the app starts:

sql.ExecNonQuery2("DELETE FROM data WHERE time < ?", Array(DateTime.Now - 7 * DateTime.TicksPerDay))

You can do a similar thing when the server starts or better every day using a timer in DB module.

Thanks Erel. I'll try it.