Slow record fetching an updates

[Pablo_Rios]

I'm working with a fixed asset inventory base with close to 6000 records.  One of the issues that I'm having is the slow record fetching after scanning a barcode.  My primary field is a formula field that pulls from the barcode field.  I have a view that only shows a minimum of fields that I need to update the record as last seen at location on what date.  When I select the current date to show when I last saw this record it lags.  I find that if I push the record up with a finger gesture on my iPad it seems to update quicker, but not always.  I've tried creating different views by sorting the barcode field to see if that would help the indexing of the field for faster record fetching, it hasn't.

Anything ideas on what to try next?  My attachments are already over 20g and I'm less than half way done with the annual inventory.

All the Best!

Pablo

[Karlstens]

How slow is slow, as in, seconds? Minutes? And how many tables do you have - are they linked? Are there many other rollup or formula fields in any of the tables?

[Pablo_Rios]

Hello Karlstens,

Slow can be approximately a minute or longer.  I actually downloaded a CSV file from The schools banner database. to Airtable, so it's actually all 1 table that I call `imported table`. No rollups. The formula field that I have is just a pull from the barcode field to the primary field.

[Karlstens]

Is there any difference in speed when running on a Desktop vs the iPad, or any other device?

[Pablo_Rios]

My desktop is ethernet, all record fetching almost instantaneous.  My iPad & IPhone lag even when I show a strong 3 bar wi-fi signal.  Of course I only scan barcodes from iPad & iPhone.

[Karlstens]

If you check the website www.fast.com from all of your terminals, do they vary greatly, or pretty much all the same?

[Pablo_Rios]

I tested my record fetching time on my work iPad via wi-fi.  It takes approximately 1 minute and 11 seconds for the record to be retrieved.  I checked my iPhone & iPad speeds on fast.com at work with the results of iPhone: 640mpbs & iPad @ 500mbps with 3 bars of wi-fi strength.

[Pablo_Rios · Accepted solution]

The issue was that my account was over by 3 gbs of attachment space.  This was being throttled by Airtable.

I split the base in half, now I have a volume 1 & volume 2 of this base. Now that the attachment space is below the 20 GB limit per base the speed improved.