Skip to Content
Jun 10, 2022 at 07:29 AM

Slow Queries


Hi i have created new company database in SAP B1as per instruction. But when i execute query with multiple tables i take 3-4 mins in new company created and 7-8 seconds in existing company.

I have rebuild all indexes and constraints in new database,clear cache and temp folders,took database offline and later brought it online,rebuild log file.

Still it takes 3-4 mins for new company only.

I am missing something.
Experts, i need your help.

Please Note : Programs and Both databases are on same server.

Server Config :
Processor : Intel (R) Xeon (R) Silver 4208 CPU @2.10 GHz 2.10 GHz
OS : Windows Server 2016
RAM : 31.5
No. of users : 7-8

Please help.