Problem with exporting large amount of data

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello all,

i am working with Suitecrm connected with the MS SQL Server 2012 database

i am having an issue with exporting large amount of data (around 10,000 rows )

The exporting script seems to be executing for ever until the server stop responding and i have to restart the server and the apache in order to make the crm works again.

I tried to change the php.ini file to allow more execution time for the script. that doesn’t seem to work as well.

Any one can help me with this issue?

Also, What do you think about the idea of having a pagination function for the list view . so that i can easily jump from page 1 to page 10 in single click ?
i hope this will be added at next upgrades.

Thank You all

2

UP

3

hello,

have you try with Reports module ?

or simply do a sql query to database. (need some skill and acces)

regards