Performance issue in Search for Date in property

[vgulshan1985]

I have developed a website in roomify and we have more than 4000 property listed on the website, When we search for Arrival and Departure date. It takes more than 15 minute to show the result.

Expected Behavior

Ideally it must appear in less than 10 seconds.

Current Behavior

It is taking more than 15 minute.

Possible Solution

Let the Roomify people finds

Steps to Reproduce from a clean installation of the latest release

1. Goto http://parallel.drupalservices.io/
2. Search for the dates.
3. You will see the issue.

I am looking forward to hear the solution. Since we have to launch in next 1 week.
3.
4.

Context (Environment)

[dani-calderon]

Hi, how did you solve this problem?

[vgulshan1985]

I have fixed it.

On Fri, 28 Sep 2018 at 3:03 PM, dani-calderon ***@***.***> wrote: Hi, how did you solve this problem? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#391 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AGrX5fXxRIJGc7FzfXJk93LkcGHGWlEUks5ufezYgaJpZM4U3avy> .

-- Sent from iPhone

[dani-calderon]

but how did you fixed it?

[vgulshan1985]

Are you facing issue?

…

On Fri, Sep 28, 2018 at 3:21 PM dani-calderon ***@***.***> wrote: but how did you fixed it? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#391 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AGrX5RfWfZLwkFlYn4IRdMf6ZyZHvdtJks5uffEbgaJpZM4U3avy> .

[dani-calderon]

Yes, the same as you: "When we search for Arrival and Departure date. It takes more than 15 minute to show the result." also with roomify

[vgulshan1985]

I have customized it and I am not using their way for checking the availability. Thanks, Gulshan

…

On Fri, Sep 28, 2018 at 3:26 PM dani-calderon ***@***.***> wrote: Yes, the same as you: "When we search for Arrival and Departure date. It takes more than 15 minute to show the result." also with roomify — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#391 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AGrX5aE6I0d8prC94yD6GKvZHcSOBSCDks5uffJAgaJpZM4U3avy> .

[dani-calderon]

ok, thanks!

[henadzIvachkin]

I have customized it and I am not using their way for checking the availability. Thanks, Gulshan
…
On Fri, Sep 28, 2018 at 3:26 PM dani-calderon @.***> wrote: Yes, the same as you: "When we search for Arrival and Departure date. It takes more than 15 minute to show the result." also with roomify — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#391 (comment)>, or mute the thread https://github.com/notifications/unsubscribe-auth/AGrX5aE6I0d8prC94yD6GKvZHcSOBSCDks5uffJAgaJpZM4U3avy .

Can you help me with same problem? Please tell me what exactly you changed in the search module.

[acrollet]

@henadzIvachkin we have not run into this issue - are you interested in sponsoring development on performance improvements for your use case? How many properties/types/units do you have entered?

[vgulshan1985]

Yes i can

On Thu, 19 Sep 2019 at 3:08 PM, Henadz ***@***.***> wrote: I have customized it and I am not using their way for checking the availability. Thanks, Gulshan … <#m_8808629041652305032_> On Fri, Sep 28, 2018 at 3:26 PM dani-calderon *@*.***> wrote: Yes, the same as you: "When we search for Arrival and Departure date. It takes more than 15 minute to show the result." also with roomify — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#391 (comment) <#391 (comment)>>, or mute the thread https://github.com/notifications/unsubscribe-auth/AGrX5aE6I0d8prC94yD6GKvZHcSOBSCDks5uffJAgaJpZM4U3avy . Can you help me with same problem? Please tell me what exactly you changed in the search module. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#391?email_source=notifications&email_token=ABVNPZILKVHQORLZJYLBABLQKNCBXA5CNFSM4FG5VPZKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD7C3UVQ#issuecomment-533051990>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABVNPZOLIVRYOWBQ53JIFNTQKNCBXANCNFSM4FG5VPZA> .

-- Sent from iPhone

[acrollet]

@vgulshan1985 we'd also be happy to review a pull request

[henadzIvachkin]

How many properties/types/units do you have entered?

around 200 props 900 types and 900 units
I have 18k sql requests in search page

[henadzIvachkin]

@vgulshan1985 how can I contact you? Or please describe the solution method.

[acrollet]

@henadzIvachkin can you provide a sample database?

[vgulshan1985]

Skype: vgulshan

…

On Thu, Sep 19, 2019 at 8:00 PM Henadz ***@***.***> wrote: @vgulshan1985 <https://github.com/vgulshan1985> how can I contact you? Or please describe the solution method. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#391?email_source=notifications&email_token=ABVNPZNAIFE5ZFCDLXJVL2DQKOEIZA5CNFSM4FG5VPZKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD7DVOWI#issuecomment-533157721>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABVNPZPWN4CEEWJXIZLIXDDQKOEIZANCNFSM4FG5VPZA> .

[henadzIvachkin]

@acrollet how can I contact you?

[acrollet]

hello@roomify.us