SQLITE

Original message was deleted

JavaBot•10/26/24, 8:50 AM

⌛⌛ This post has been reserved for your question.

Hey @Mookha! Please use
/close
/close
or the Close PostClose Post button 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.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

Nothing•10/26/24, 8:50 AM

I 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?

dan1st•10/26/24, 8:52 AM

what do you mean with dead tuple?

Ddan1st what do you mean with dead tuple?

Nothing•10/26/24, 8:53 AM

heh

dan1st•10/26/24, 8:53 AM

and why would it be unnecessary resource usage?

Ddan1st and why would it be unnecessary resource usage?

Nothing•10/26/24, 8:53 AM

Well it will still work even if there are no lines to delete

dan1st•10/26/24, 8:55 AM

idk what you mean with deleting lines but did you measure it being a problem?

Ddan1st idk what you mean with deleting lines but did you measure it being a problem?

Nothing•10/26/24, 8:59 AM

Even without death tuple, it will still copy and paste when using VACUUM

dan1st•10/26/24, 9:00 AM

I 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?

dan1st•10/26/24, 9:01 AM

Also most stuff you might think being a problem in terms of resource consumption/performance isn't

Ddan1st I dtill have no idea what you mean with dead tuple but you can first check wheth...

Nothing•10/26/24, 9:02 AM

I don't know how to express it anymore

Ddan1st Also most stuff you might think being a problem in terms of resource consumption...

Nothing•10/26/24, 9:07 AM

I just wonder if there is any problem with VACUUM abuse?

dan1st•10/26/24, 9:18 AM

I have no idea why you are even using the VACUUMVACUUM command here

dan1st•10/26/24, 9:20 AM

If you don't have a performance issue that is measurable, don't use it

Ddan1st I have no idea why you are even using the `VACUUM` command here

Nothing•10/26/24, 9:25 AM

I want to automate it, it's very annoying to have to do it manually every month

dan1st•10/26/24, 9:27 AM

So your question is how to run that code every month?

Ddan1st So your question is how to run that code every month?

Nothing•10/26/24, 9:28 AM

No, I'm just looking for a way to clean up dead tuple

Ddan1st So your question is how to run that code every month?

Nothing•10/26/24, 9:29 AM

but I don't know when it is necessary

Nothing•10/26/24, 9:29 AM

Can storing too many dead tuples reduce performance?

NNothing No, I'm just looking for a way to clean up dead tuple

dan1st•10/26/24, 9:30 AM

You have still not said what you mean with dead tuple

dan1st•10/26/24, 9:31 AM

But if you don't measure an issue, don't do it

Nothing•10/26/24, 9:31 AM

clean up...

Ddan1st But if you don't measure an issue, don't do it

Nothing•10/26/24, 9:32 AM

Maybe 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.

Nothing•10/26/24, 9:32 AM

If a month doesn't exceed 500 dead rows then it's not a problem

dan1st•10/26/24, 9:34 AM

You still haven't said what you meant with "dead rows"

Ddan1st You still haven't said what you meant with "dead rows"

Nothing•10/26/24, 9:35 AM

dead tuple

dan1st•10/26/24, 9:35 AM

SQLite normally puts new rows at the place where it had deleted rows before if possible

dan1st•10/26/24, 9:35 AM

I don't know how you mean with dead tuple

Ddan1st SQLite normally puts new rows at the place where it had deleted rows before if p...

Nothing•10/26/24, 9:35 AM

are u sure about that ??

JavaBotAPP•10/26/24, 9:35 AM

https://tryitands.ee/

Ddan1st I don't know how you mean with dead tuple

Nothing•10/26/24, 9:36 AM

are u kidding me

dan1st•10/26/24, 9:36 AM

you still haven't explained that

dan1st•10/26/24, 9:36 AM

Also you can use auto_vacuumauto_vacuum mode with SQLite

Ddan1st no

Nothing•10/26/24, 9:37 AM

it will work when included in free_list so it cannot be replaced by itself

Ddan1st SQLite normally puts new rows at the place where it had deleted rows before if p...

dan1st•10/26/24, 9:37 AM

Note. This may not happen if you are just using a bit of data

NNothing it will work when included in free_list so it cannot be replaced by itself

dan1st•10/26/24, 9:37 AM

Ddan1st Also you can use `auto_vacuum` mode with SQLite

Nothing•10/26/24, 9:37 AM

auto_vacuum

auto_vacuum

dan1st•10/26/24, 9:38 AM

What about it?

Nothing•10/26/24, 9:38 AM

no defragmentation

dan1st•10/26/24, 9:38 AM

I don't know what you mean if you throw incomplete sentences at me without saying what you are asking

dan1st•10/26/24, 9:39 AM

In most cases, you should never have to use the VACUUMVACUUM command with the default settings AFAIK

Ddan1st In most cases, you should never have to use the `VACUUM` command with the defaul...

Nothing•10/26/24, 9:39 AM

In general, DEAD TUPLES will occur when there is an update or delete

Nothing•10/26/24, 9:40 AM

it will always exist a death row when updating or deleting in the database

dan1st•10/26/24, 9:40 AM

and is there any reason to believe SQLite doesn't put new rows instead of it if it can in your specific case?

Nothing•10/26/24, 9:41 AM

Nothing•10/26/24, 9:42 AM

Not really related, but I don't have an example for this case

dan1st•10/26/24, 9:42 AM

if you have free space in the table, SQLite should be able to fill it when new data comes in

SQLITE

Similar Threads

Similar Threads

Similar Threads