I use a script involving googletrans==4.0.0-rc1, there is a problem with this package, which is limited requests.

My solution when I connect to SQL server is to create a flag column(what record has been translated and what hasn’t gone through translation), to translate new rows only and append rather than over writing.

Is there a solution where I can send thousands of records at once(I need it for a separate scenario).

>Solution :

Unfortunately, the limitation on the number of requests you can make to the Google Translate API is set by Google and cannot be changed by the googletrans package.

However, there are a few things you can do to work around this limitation. One option is to use multiple API keys and rotate them as you make requests. Another option is to use a different translation service that does not have the same limitations.

Alternatively, if you need to translate thousands of records at once, you may want to consider using a batch translation service. These services are designed to handle large amounts of text and can translate thousands or even millions of records at once. Some examples of batch translation services include Microsoft Translator Hub, Amazon Translate, and Google Cloud Translation API.

Keep in mind that batch translation services may come with their own limitations and costs, so be sure to review the documentation and pricing before selecting a service.