Small and medium business | Business Central, N...

Configuration package: Is there a way to reduce the no. of database?

(1) Share

Report

Posted on by joshtechsolutions

4,989

hi Community,

I was trying to upload the configuration package, and come to realize that even though I may have only 200 over lines, Navision will go and update/scan through 50k over database just to upload my 200 over lines.

May I know if there is anyway to reduce this?

Also initially when I started doing update, I don't see 50k+, but it seems to be gradually happening, what is the cause of this?

Thank you.

Categories:

Microsoft Dynamics NAV

I have the same question (0)

All responses (7)

Answers (0)

PRao 394 on at

Like (1)

Report
Copy link

Link copied!

I believe there is some blank line in your package which is you are importing.

You must click on No. Of database Record lookup and check whether by default some entry is getting created or not.

Thanks

PRao

Was this reply helpful? Yes No
joshtechsolutions 4,989 on at

Like (0)

Report
Copy link

Link copied!

Hi PRao,

I have checked that there are no access blanks in my excel. However, it could be that previously excessive blanks have been uploaded, if this is the case how can I remove them from this database?

Thank you !

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,586 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

That field indicates the number of records currently stored in the system for that table. If you're looking to reduce that number, the only way to do so is by deleting existing records from the system. However, I don’t think that’s what you’re aiming to do.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
joshtechsolutions 4,989 on at

Like (0)

Report
Copy link

Link copied!

Hi Valentin Castravet

Thank you for your reply.

I'm curious how I can delete the records, if you can show me the steps.

From what I can see, every time I add a record to a table, the no. of databases increases something which I don't quite understand,

since the records have been the same fields.

I'm trying to keep the records as low as possible so that the time to validate and apply can be shorter.

Please advise.

Thank you.

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 25,394 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi

I hope this can help you and give you some hints: 4 Ways To Delete Records From a Table - Business Central Deep Dive

Best

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,039 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, This value is not the data you are importing, but the data already in the database. If you want to reduce it, you must clear it from the database.

I'm not sure what table you are importing, you can try the following options in a test company.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
joshtechsolutions 4,989 on at

Like (0)

Report
Copy link

Link copied!

Hi YUN ZHU ,

Thank you for your advise.

I don't seems to see the column called "Delete Table Records before Processing" in older BC configuration package.

May I ask what if the configuration package has already been applied, then how do we proceed to check and remove any excessive data records from the server?

Will that be a developer's role to do that?

Thank you !

Was this reply helpful? Yes No