How to reduce the database

Why? how large is the database?

You should check regulations where you are. Some require things like posted invoices etc. to be retained for several years.

nverma wrote:

You can delete unused keys from your code and unused fields form tables and forms.

go file -> database -> information -> tables -> optimize...

Huh?

bbrown wrote:

Why? how large is the database?

You should check regulations where you are. Some require things like posted invoices etc. to be retained for several years.

:thumbsup:

We need an idea of your size.

I have also deleted all posted invoices, posted shipments, posted credits.
I like to keep 4-5 years worth od docs. I clean out at the end of each year the ones that are older.

But I do make & keep a backup of the database before doing so just in case I ever need to pull them up again.

Do you also keep item pics stored in blob fields? depending on the number of items this can be a ton of space. That's why we keep the item pics on a separate server and they get "pulled" when the item card is opened.

is the thought to reduce the size beacuse you are reaching a limit? or are you looking to increase speed?

I find it easiest to go to the posted invoice header table.
filter on posting date the range you want.
select all-> delete key.

if you have a backup server - install a backup of the most recent copy of the database.
then you can test deleting certain things to see if it actually achieves what you aiming for.