Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 03, 2024 05:52 AM
I'm seeing very slow requests when fetching a single record from a table with 4 records.
Very slow as in more than a minute.
What am I doing wrong?
2 Replies 2
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 03, 2024 06:43 AM
Hello @toffu
Please include more details like which programming language you're using. Which library are you using and what are the specific codes for fetching records from your table?
Just share a screenshot or code of it.
Just make sure you hide all sensitive information.
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 03, 2024 07:01 AM
Thank you, sure.
I use python:
def fetch_company_id_by_property(property_name, value):
logger.info("Fetching company by %s: %s", property_name, value)
field_name = getattr(Company, property_name).field_name
formula = match({field_name: value})
company = Company.first(formula=formula)
if company:
logger.info("Company: %s %s", company.website_url, company.id)
return company.id
