Tag Info

New answers tagged

2

If (and it's a big if) the format remains constant with a number and a unit, you should be able to create a case statement that will get the total of the smallest unit. In your example, let's use days as the smallest unit: CASE WHEN timeToMaturity LIKE '%Days' THEN cast(rtrim(timeToMaturity,'abcdefghijklmnopqrstuvwxyz')as INT) * 1 WHEN ...


1

Paradigma Software introduces Valentina Server 6.0 (in beta testing now), which is 3 in 1: Valentina DB Server Valentina SQLite Server Valentina Report Server SQLite Server uses SQLite engine without changes, WAL enabled. SQLite Server works on 3 OS: Mac, Win, Linux. You can use Valentina Studio (free) application to manager this DB Server, as well as ...


1

This depends on the needs of the data and is also a design preference. Having CASCADE ON DELETE can be a cleaner implementation and better describe the relationship of the data. The research that this article presents shows that CASCADE ON DELETE actually has a slight performance decrease over a straight delete in SQLite. But unless you have a consistently ...


0

If it's possible in your environment, just split your database to "shards" or to date ranges (eg. users 1-100000 in shard 1, 100001-200000 in shard 2 etc.). If you manage (from functional point of view) to have multiple *.sqlite files, then just put them on different drives. This way you will split the load on OS level, which gives you a much better ...



Top 50 recent answers are included