Delivery ticket lister proccesing very slow issue

[QMcKay]

@marannorama

My database, sambapos.sdf mean CE is it correct?

Correct.

@marannorama

should I use sql express?

Yes.

@marannorama

Can I load sambapos with sql express database or firstly load with CE then convert to it SQL?

Follow the instructions to install SQL Express 2014.
Then follow the instructions to convert CE to Express (within the same Installation & Setup Tutorial).
Then run SambaPOS and change your connection string.

SQL Express 2014 Installation - SambaPOS4 Database Setup - [BONUS] How to Convert from CE to SQL Express

Microsoft SQL Express 2014 SQL Express 2014 Download Link Versions Available Express 32BIT WoW64\SQLEXPR32_x86_ENU.exe Express 32BIT\SQLEXPR_x86_ENU.exe Express 64BIT\SQLEXPR_x64_ENU.exe ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe LocalDB 32BIT\SqlLocalDB.msi LocalDB 64BIT\SqlLocalDB.msi - MgmtStudio 32BIT\SQLManagementStudio_x86_ENU.exe - MgmtS…

@marannorama

SQL 2012 OR 2014 better?

SQL Express 2014 is better.