[Vtigercrm-developers] 500k to leads changing a lot

[Uma S]

Hi Ruben,

Thanks! for the details shared.

Let's re-check this char-set issue with the latest 7.3.0 instance to verify.

On Thu, Dec 24, 2020 at 8:10 AM Tony Sandman <tonysandman999 at gmail.com>
wrote:

> Same this: &
>
> T
>
> On Thu, Dec 24, 2020, 2:04 AM Rubén A. Estrada Orozco <rulotec1 at gmail.com>
> wrote:
>
>> Sure Uma,
>>
>> For example: "Rubén". Create that item in a picklist. Then create a csv
>> file containing rows using the same value and do an import.
>> Not only Vtiger won't be able to recognize the value already exists, but
>> it will create a new value for each row. So, if your csv contains 10 rows
>> you'll end up with something like this in your picklist:
>>
>> Rubén
>> Rubén
>> Rubén
>> Rubén
>> Rubén
>> Rubén
>> Rubén
>> Rubén
>> Rubén
>> Rubén
>> Rubén
>>
>>
>> I'm not 100% sure that vtiger will store é as the htmlentity &eacute. It
>> might be something else because it was a long time ago that I saw that
>> behaviour and since then I do not use accents in picklists. I don't know
>> about other languages, but latin languages (spanish, french, italian,
>> portuguese, ...) will have the same problem because of accents.
>>
>> Saludos
>>
>> Rubén
>>
>>
>> On Tue, Dec 22, 2020 at 11:19 PM Uma S <uma.s at vtiger.com> wrote:
>>
>>> Hi Ruben,
>>>
>>> Can you share an example for these picklist values which is leading to
>>> this issue?
>>>
>>> On Wed, Dec 23, 2020 at 4:11 AM Rubén A. Estrada Orozco <
>>> rulotec1 at gmail.com> wrote:
>>>
>>>> The problem with duplicate picklist entries has happened to me as well.
>>>> In my case it was because of using accents. Since then I never use accents
>>>> and try to avoid most special characters in picklists. That's a bug and
>>>> should be fixed though.
>>>>
>>>> Saludos
>>>>
>>>> Rubén
>>>>
>>>>
>>>> On Tue, Dec 22, 2020 at 3:08 PM Tony Sandman <tonysandman999 at gmail.com>
>>>> wrote:
>>>>
>>>>> Seems like import duplicated picklist values creating thousands of
>>>>> picklist entries. Should not happened actually?
>>>>> Sniffing around...
>>>>>
>>>>> On Tue, Dec 22, 2020 at 12:51 AM Rubén A. Estrada Orozco <
>>>>> rulotec1 at gmail.com> wrote:
>>>>>
>>>>>> turn on the slow queries log of mysql/mariadb. That will give you a
>>>>>> hint of where the bottleneck is.
>>>>>>
>>>>>> Also, how much ram memory do you have? increasing ram would probably
>>>>>> help.
>>>>>>
>>>>>> Saludos
>>>>>>
>>>>>> Rubén
>>>>>>
>>>>>>
>>>>>> On Sun, Dec 20, 2020 at 8:15 PM Tony Sandman <
>>>>>> tonysandman999 at gmail.com> wrote:
>>>>>>
>>>>>>> So, I get around 500k to leads and from that moment to get edit
>>>>>>> record I need to wait 30s.
>>>>>>> removed imported but the issue persists. Is it something observed
>>>>>>> before?
>>>>>>>
>>>>>>> T
>>>>>>> _______________________________________________
>>>>>>> http://www.vtiger.com/
>>>>>>
>>>>>> _______________________________________________
>>>>>> http://www.vtiger.com/
>>>>>
>>>>> _______________________________________________
>>>>> http://www.vtiger.com/
>>>>
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>
>>>
>>>
>>> --
>>> With
>>> Best Regards
>>> Uma.S
>>> Vtiger Team
>>> _______________________________________________
>>> http://www.vtiger.com/
>>
>> _______________________________________________
>> http://www.vtiger.com/
>
> _______________________________________________
> http://www.vtiger.com/



-- 
With
Best Regards
Uma.S
Vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20201224/d34547bc/attachment.html>