eMO Booking could not possible in Point of Sale Module

While booking eMO in Point of Sale Module it may shown the error message as Query Timeout expired.

1. Please flush all the data up to last 2 months and shrink the database. 
2. Clear the log also. Then performance will be faster. 
3. Flushing the data should be done at your end day to day (during the period when bulk eMOs are booked) and month by month during the normal eMO booking. 
4. Flush till last two months. Then run the below query in sql query analyser. 
5. Until you flush the old data there will not be any improvement 

USE eMO GO
ALTER DATABASE eMO SET RECOVERY simple GO
DBCC SHRINKFILE (eMO_log , 1) Go
ALTER DATABASE eMO SET RECOVERY Full use eMO GO
DBCC DBReindex ('eMOInward',' ',90) GO
DBCC DBReindex ('eMOOutward',' ',90)