Ok sure. the thing is I gave new FTP details as old server is gone.

@Faiz I have sent the details

Also, tested with 1000 records database and its working fast. But the database with 8000 record the above search page is slow.

Dear Team, We have one guest house with nearly 250 rooms. While searching perticular this room mysql taking more than 100% CPU usage and page loading slowly take to 7 to 8 seconds. Is there any remedy for this?
Note: Other guesthouse with less rooms working fast

Steps to duplicate the issue.

1. Login to admin area and click on "Book now"
2. Select the From and To date.
3. Select the Guest house name and click on "Search".

server: Ubuntu 18.04
mysql 5.7
PHP 5.6

Thank you Team for the help.

@Faiz I want to remove that functionality. Please let me know which codes I can comment.

Dear Team,

Can we disable partially available functionality by disabling some part of code. Please help on this.

Dear Team,

For example after 4 o clock customer going to checkout from his room. But that room is not available for booking on same day. is this possible to make this available for booking on same day after 4 o clock?

Sorry, I think we have selected 1 months date. So we got partially available room. that has been booked again casing the issue. Could you please help me to understand Partially available room and Unavailable rooms.

There is a bug in the system as below:
In out test I could see we can book same room twise. After we booking all it was showing error as "Invalid Order". However in the invoice I could see the double room booked. Please resolve this.