SambaPOS Forum

English Boards => Support => Topic started by: evail on January 08, 2013, 09:48:28 am

Title: Reports generating very slowly
Post by: evail on January 08, 2013, 09:48:28 am

Hello Emre,

Being long time, my only issue and support that i need is regarding the slow reports.

It takes a long time to generate monthly reports. Is there anyway i can solve this.

thanks

Title: Re: Reports generating very slowly
Post by: emre on January 08, 2013, 10:25:30 am

Hello evail,
*Which database are you using?
*Are you using 2,99?
*What do you mean by long time? Seconds or minutes?

Title: Re: Reports generating very slowly
Post by: evail on January 09, 2013, 05:57:44 am

I am using 2.99

To be specific my monthly transaction is around 10,000.

It takes like more than 5 minutes maybe closer to 10 minutes for the report to generate.

System is a quad i would is it is very fast.

Thanks

Title: Re: Reports generating very slowly
Post by: emre on January 09, 2013, 06:15:32 am

If it is SQL Compact database you should upgrade to SQL Express. 10.000 Transactions is too much for SQL Compact.

If it is already SQL Express please send a backup of your database to info@sambapos.org

Title: Re: Reports generating very slowly
Post by: evail on January 14, 2013, 11:20:17 pm

Hey Emre,

Sorry for the late response.

Well i do not know which one I have, I only installed SambaPOS.

I am guessing its SQL Compact.

How can I change it to Express?

Thanks

Title: Re: Reports generating very slowly
Post by: evail on January 15, 2013, 09:30:30 pm

I just found this link, to change to sqlexpress

http://doc.sambapos.org/doku.php/en/dbase/client_server_baglantisi_nasil_yapilir (http://doc.sambapos.org/doku.php/en/dbase/client_server_baglantisi_nasil_yapilir)

I am trying this right now, another question is how can i have all the data transferred?

thanks

Title: Re: Reports generating very slowly
Post by: emre on January 16, 2013, 04:37:58 am

You can use this tool to generate a data transfer script
http://sqlcetoolbox.codeplex.com/ (http://sqlcetoolbox.codeplex.com/)

Title: Re: Reports generating very slowly
Post by: evail on January 16, 2013, 09:12:46 am

I used the tool to create the scripts.

how do i insert it to the sqlexpress db?

thanks

Title: Re: Reports generating very slowly
Post by: emre on January 16, 2013, 03:25:37 pm

The easiest way will be using SQL Management Studio tool for your SQL Express version. I'm using it.
If you didn't installed it while setting up SQL Express you can download it separately. But unfortunately SQL Management studio is a big download.

I didn't tried them before but you can try one of these free alternatives
http://forum2.sambapos.org/index.php/topic,828.msg4286.html#msg4286 (http://forum2.sambapos.org/index.php/topic,828.msg4286.html#msg4286)
If you try them please share your experiences.

Thanks.

Title: Re: Reports generating very slowly
Post by: evail on January 16, 2013, 09:52:03 pm

Thanks emre,

Searched the forum and found the link below, it worked great, and its so fast :D
Thanks again.

http://forum2.sambapos.org/index.php/topic,271.msg2716.html#msg2716 (http://forum2.sambapos.org/index.php/topic,271.msg2716.html#msg2716)