[5GB DB] Slowness on first startup

Development
21

Was my action justified, or had Gladys already done it?

22

It was justified, at the moment we don’t perform manual VACUUM.

It’s also something we’ll need to add with all these automatic « clean Â» topics, maybe overnight with a scheduled time that we control (and of course outside Gladys Plus backup windows / and aggregations)

23

Hi @pierre-gilles,

I was waiting for you to come back before posting
 It’s been 2 weeks that all my Gladys home automation has been crashing, no Gladys Plus backup again and recurring crashes after 30 minutes
 I’m desperate, I’m starting to wonder if SQLite isn’t hitting its limits for me. ^^ I’ve turned everything off for 4 days, only my Gladys Pro Dev is running, it works fine.

If you have a bit of time at some point
 Thanks in advance.

24

Hi @Terdious! Oh no!

Would you mind sending me your DB (a link by email, for example)? So I can analyze the volume of data we’re talking about, and test locally on my machine how it runs.

We can also call today if you’re available so you can show me this and explain it to me :slight_smile:

I don’t think so, SQLite is solid and it can store terabytes of data, I think you’re far from that!

25

@pierre-gilles,

Thanks for your time already.
I’ll send that to you via WeTransfer as soon as I get back from work (the Pi’s power being cut)

I’m only available from 5:30 PM, if that works for you!!

26

Ok thanks! :wink:

For 5:30 PM, we’ll keep each other updated — it should be fine but I might have something on tonight!

27

I confirm that’s fine for 5:30 PM, I’ll send you a Google Meet link in a DM :slight_smile: