Speed when hosted locally

Hi all - what kind of performance improvements can one expect if erpnext is hosted locally or on a server closer to our users?  I’m particularly interested in improving performance in form for the link fields which are rather slow since they have to validate the selection from another table. Any experience shared would be helpful.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     
Laurence,

best way is to do a trial.

FYI, we looked at the Item query again we found that in the search, there was an end_of_life condition that could considerably slow down the query and since it was already a validation, we removed the condition from search - I think it should help a lot more. We will push this a bit later - please let us know if there is an improvement in the Item search.

What we can also do is cache the Item table in the client-side - this will make loading a bit slower but once the table is loaded, the item selection could be much faster... 

best,
Rushabh


T: @rushabh_mehta

On 29-Jul-2013, at 6:17 AM, lxnow <la...@union.ph> wrote:

Hi all - what kind of performance improvements can one expect if erpnext is hosted locally or on a server closer to our users?  I'm particularly interested in improving performance in form for the link fields which are rather slow since they have to validate the selection from another table. Any experience shared would be helpful.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     
* Trial - You're right, of course, about doing a trial. Something to possibly do later on when I have more time.
* end_of_life condition - not sure what this means exactly but if / when you do remove this validation, please update here so we can compare
* local caching - love this idea. I would imagine that this would create a whole bunch of new possible issues for other users. Maybe a toggle in Setup for local caching for the entire system? Or by user (more work for this option I suppose)?







On Mon, Jul 29, 2013 at 3:41 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Laurence,

best way is to do a trial.

FYI, we looked at the Item query again we found that in the search, there was an end_of_life condition that could considerably slow down the query and since it was already a validation, we removed the condition from search - I think it should help a lot more. We will push this a bit later - please let us know if there is an improvement in the Item search.

What we can also do is cache the Item table in the client-side - this will make loading a bit slower but once the table is loaded, the item selection could be much faster...

best,

Rushabh

On 29-Jul-2013, at 6:17 AM, lxnow <la...@union.ph> wrote:

Hi all - what kind of performance improvements can one expect if erpnext is hosted locally or on a server closer to our users? I'm particularly interested in improving performance in form for the link fields which are rather slow since they have to validate the selection from another table. Any experience shared would be helpful.



Note:



If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







Note:



If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note



    You received this message because you are subscribed to a topic in the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/HRIauzw_Q4A/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







--
Laurence Cua
Set. Sleep. Save.
20% Energy Savings with Union Perfect Timing



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     
Hi Laurence,

Refresh and try fetching items now. We have removed the end of life condition from the query. Let us know if it has made any improvements.

Thanks,
Anand.

On 29-Jul-2013, at 1:17 PM, Laurence Cua <la...@union.ph> wrote:

* Trial - You're right, of course, about doing a trial.  Something to possibly do later on when I have more time.
* end_of_life condition - not sure what this means exactly but if / when you do remove this validation, please update here so we can compare
* local caching - love this idea. I would imagine that this would create a whole bunch of new possible issues for other users. Maybe a toggle in Setup for local caching for the entire system? Or by user (more work for this option I suppose)?







On Mon, Jul 29, 2013 at 3:41 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Laurence,

best way is to do a trial.

FYI, we looked at the Item query again we found that in the search, there was an end_of_life condition that could considerably slow down the query and since it was already a validation, we removed the condition from search - I think it should help a lot more. We will push this a bit later - please let us know if there is an improvement in the Item search.

What we can also do is cache the Item table in the client-side - this will make loading a bit slower but once the table is loaded, the item selection could be much faster... 

best,

Rushabh

On 29-Jul-2013, at 6:17 AM, lxnow <la...@union.ph> wrote:

Hi all - what kind of performance improvements can one expect if erpnext is hosted locally or on a server closer to our users?  I'm particularly interested in improving performance in form for the link fields which are rather slow since they have to validate the selection from another table. Any experience shared would be helpful.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 





Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to a topic in the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/HRIauzw_Q4A/unsubscribe.

To unsubscribe from this group and all its topics, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 




--
Laurence Cua
Set. Sleep. Save. 
20% Energy Savings with Union Perfect Timing




Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.