Optimization of database operations
11 USD The data from this table will then be moved and updated if there are conflicts (there are unique failure indices that need to be updated in certain columns )
Now the code on the digital ocean server is running in 30 seconds, which is unacceptable.
Please write down who can do the surgery as quickly as possible.
The code is written on a python. server crime - 2 vCPUS 2GB / 60GB Disk ($18/mo)
In general, do you really want to do this surgery in a second or less?
Case-- take the currencies from the csv file and they need to be transferred to the database by updating it and spending a new time there.
The project is mine, not commercial, and the budget is very small.
-
2 days33 USD
135 2 0 2 2 days33 USD
Здравствуйте. Можно попытаться оптимизировать код. Не факт что будет одна Секунда, но можно попытаться сократить это время до 10 или даже 5 секунд
-
А можете предоставить копию этой БД с дампом и скриптом?
Раз уж некоммерческий... -
отправил дамп
-
Код написан на питоне.Характиристики сервера - 2 vCPUs 2GB / 60GB Disk ($18/mo)
///если диск не ссд, то вообще не установить ли себе дома с оплатой айпи да трафика при
\\\ 2Гб оперативки - сколько же чему выделено
/// да и проц неизвестных характеристик. вобщем много ньюансов
как по вашему 350тыс.строк и немало столбцов
должны пройти за секунду ? -
Код написан на питоне. И окажется, что не только в нем причина.
может лучше код выложить ?
-
а можно и мне csv файл, кусок кода на питоне и таблицу, куда все потом попадает
-
Current freelance projects in the category Databases & SQL
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 1 day 10 hours back ∙ 5 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 2 days 1 hour back ∙ 8 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 7 days back ∙ 12 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 7 days 11 hours back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 10 days 18 hours back ∙ 16 proposals |
Kharkiv