web-erp-developers

[WebERP-developers] Can we change the fields length?

[ExsonQu <hex...@gm...>]

*Dear all:*

               Can we change the length for stock category id from 6 to 20
and stock id from 20 t0 30? 

               Thanks and best regards!

              Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Can-we-change-the-fields-length-tp4657090.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Can we change the fields length?

[Phil D. <ph...@lo...>]

Hi Exson,

Please could you describe the drivers for this proposal?
I am not keen on the face of it because
the stockid is shown on quite a lot of reports and space is often at a 
premium - all these reports would need re-writing.
I think 20 varchar is ample for stockid and 6 fine for stock 
categories.  This change probably belongs in the customers own branch - 
unless there is some logic I am missing.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 17/12/13 21:58, ExsonQu wrote:
> *Dear all:*
>
>                 Can we change the length for stock category id from 6 to 20
> and stock id from 20 t0 30?
>
>                 Thanks and best regards!
>
>                Exson
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Can-we-change-the-fields-length-tp4657090.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Can we change the fields length?

[Vitaly S. <vsh...@so...>]

Hi all,

I have all modifications done in my system to use 30 characters in stock 
id. I would love to to add them to the trunk, if you decided to adopt 
this proposal.

Vitaly

On 12/17/2013 3:29 AM, Phil Daintree wrote:
> Hi Exson,
>
> Please could you describe the drivers for this proposal?
> I am not keen on the face of it because
> the stockid is shown on quite a lot of reports and space is often at a
> premium - all these reports would need re-writing.
> I think 20 varchar is ample for stockid and 6 fine for stock
> categories.  This change probably belongs in the customers own branch -
> unless there is some logic I am missing.
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 17/12/13 21:58, ExsonQu wrote:
>> *Dear all:*
>>
>>                  Can we change the length for stock category id from 6 to 20
>> and stock id from 20 t0 30?
>>
>>                  Thanks and best regards!
>>
>>                 Exson
>>
>>
>>
>> --
>> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Can-we-change-the-fields-length-tp4657090.html
>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>>
>> ------------------------------------------------------------------------------
>> Rapidly troubleshoot problems before they affect your business. Most IT
>> organizations don't have a clear picture of how application performance
>> affects their revenue. With AppDynamics, you get 100% visibility into your
>> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
>> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2014.0.4259 / Virus Database: 3658/6925 - Release Date: 12/16/13
>
>

Re: [WebERP-developers] Can we change the fields length?

[ExsonQu <hex...@gm...>]

*Hi, Phil,*

            Thank you for your reply.
            Tim has a good explain for this. So I attached in the following.
Thank you very much Tim. I think we should not increase the length of the
categoryid. And according to Tim's information, I think we should try to
avoid using the stock ID too. But I think it's a tough job as Phil said. 

              I agree keep the current status. 

             And thank you Vatily for your advice. It's better keep it as is
for the benefit of users who use MRP features.

             Thank you all. I appreciated everyone's help from such a global
community. It's a warm feeling!

              Best regards!

              Exson
             

    


          
<quotation from Tim>
Increasing the size of primary key fields increases the time the
database engine takes to query those tables. There are already some
parts of webERP that are unusable for large stockmaster tables (you
showed me a report once and somebody else has mentioned MRP which
slows exponentially as the size of stockmaster increases). I'm not
sure I see a "use case" for this. I may be wrong but I can't remember
anywhere in webERP that the user would actually see the category ID as
opposed to the category name (except of course in the category
maintenance screen) and if there is, it should be removed.

Tim
</quotation>



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Can-we-change-the-fields-length-tp4657090p4657095.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.