Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 05, 2023 11:18 AM
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
Solved! Go to Solution.
Mar 05, 2023 11:09 PM
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.
Jan 05, 2023 12:33 PM
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?
Jan 05, 2023 12:48 PM
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.
Jan 05, 2023 02:04 PM
Is there any difference in speed when running on a Desktop vs the iPad, or any other device?
Jan 05, 2023 03:10 PM
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.
Jan 05, 2023 03:17 PM
If you check the website www.fast.com from all of your terminals, do they vary greatly, or pretty much all the same?
Jan 09, 2023 01:07 PM
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.
Mar 05, 2023 11:09 PM
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.