Truncate older data from database
I am using MySQL as my data source for my Bonita application. There is a SELECT query that the application runs that takes a very long time to execute. I believe the reason is because the table that the query is referencing has many rows and values so it times out. This query causes the Bonita system to hang. I wanted to know is it possible to truncate the older data so when this SELECT query runs, it will not have to scan all rows in that table? I am using Bonita Community Edition, version 6.3.2. MySQL version 5.6.19. The data source is on the same server as the app server.
Moreover, if that solution is not possible, how much effort is it to move the data from MySQL to SQL Server? What configurations in the bonita installation need to be made to reference this new data source?