JJ⌛Hey @Mookha! Please useor the/closebutton above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically marked as dormant after 300 minutes of inactivity.Close Post
TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.
NI have it enabled every time the code is enabled (it will be restarted daily) so this can lead to unnecessary resource usage even without the dead tuple, is there a good solution for this case?
Dwhat do you mean with dead tuple?
Nheh
Dand why would it be unnecessary resource usage?
NWell it will still work even if there are no lines to delete
Didk what you mean with deleting lines but did you measure it being a problem?
NEven without death tuple, it will still copy and paste when using VACUUM
DI dtill have no idea what you mean with dead tuple but you can first check whether it exists and don't execute stuff if it doesn't exist?
DAlso most stuff you might think being a problem in terms of resource consumption/performance isn't
NI don't know how to express it anymore
NI just wonder if there is any problem with VACUUM abuse?
DI have no idea why you are even using the
VACUUM command hereDIf you don't have a performance issue that is measurable, don't use it
NI want to automate it, it's very annoying to have to do it manually every month
DSo your question is how to run that code every month?
NNo, I'm just looking for a way to clean up dead tuple
Nbut I don't know when it is necessary
NCan storing too many dead tuples reduce performance?
DYou have still not said what you mean with dead tuple
DBut if you don't measure an issue, don't do it
Nclean up...
NMaybe so, I'm not sure but I might let them use it for a while to see how many dead spots they create in the database.
NIf a month doesn't exceed 500 dead rows then it's not a problem
DYou still haven't said what you meant with "dead rows"
Ndead tuple
DSQLite normally puts new rows at the place where it had deleted rows before if possible
DI don't know how you mean with dead tuple
Nare u sure about that ??
J
Nare u kidding me
Dno
Dyou still haven't explained that
DAlso you can use
auto_vacuum mode with SQLiteDNote. This may not happen if you are just using a bit of data
N.
NDWhat about it?
Nno defragmentation
DI don't know what you mean if you throw incomplete sentences at me without saying what you are asking
DIn most cases, you should never have to use the
VACUUM command with the default settings AFAIKNIn general, DEAD TUPLES will occur when there is an update or delete
Nit will always exist a death row when updating or deleting in the database
Dand is there any reason to believe SQLite doesn't put new rows instead of it if it can in your specific case?
N
NNot really related, but I don't have an example for this case
Dif you have free space in the table, SQLite should be able to fill it when new data comes in
