Help

Re: Slow record fetching an updates

Solved
Jump to Solution
3526 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Pablo_Rios
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Pablo_Rios
6 - Interface Innovator
6 - Interface Innovator

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.

See Solution in Thread

7 Replies 7

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?

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.

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

Pablo_Rios
6 - Interface Innovator
6 - Interface Innovator

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.

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

 

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
6 - Interface Innovator
6 - Interface Innovator

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.