Will pass through query be faster?

[GBalcom]

I have an application I'm building where there will be a local front end, and an MS SQL Server back end, hosted in the cloud.

In this application, I have one continuous form that has a high definition picture for each record, there are 30 records total. When I had the back end on my local server, it was very fast. I just migrated the back end to my hosted account, and now it's very slow.

I've changed the record source to a pass through query, but it appears it's looking for a username and password for each individual record. I'm wondering if I can do some VBA on the "On_Load" event of the form to populate the recordset with the password, so the user isn't prompted for a password I don't want them to have?

Also, would a pass through be any faster in this instance? I'm sure it's the pictures that are causing an issue, but I really don't want to lose the picture quality.

As a last resort, the pictures will be the same everytime, and this is a "static" table (the user will not add records), so as an absolute last resort, I could somehow make the images local....but I hate to do that because of the maintenance nightmares (all users are outside of my office, and are my clients, not co-workers)

Thanks for any insight!

Ps...WebAdmin, feel free to move this to any forum you see fit. I had a hard time deciding where this topic should be.

 

[pbaldy]

A pass through might help if the issue was with selecting records, but that doesn't sound like the case. 30 large pictures are simply going to take longer to pull from the cloud than through a local network. Even a fast internet connection is typically much slower than the 100-1000mb speed of a LAN.

A local table is certainly an alternative, and if appropriate you could empty/fill it when the application starts, so the speed issue only occurs once.

 

[GBalcom]

Thank you Pbaldy,
I see your point. I wonder if I should consider a local temp table. something that loads that complete table (30 records or so) upon startup, and deletes them all on closing.
If I were to go this route, is it ok to leave that temp table in my accde front end, or do I need to create a separate local back end for this table?

Thanks!

 

[pbaldy]

I would put a table in the front end, but others may have other opinions. A separate file avoids the bloat of deleting and populating each time, but compacting solves that easily enough.

 

[smig]

If you never change the pictures attached to each record I wont even empty the local table and only getting the new ones.

If you do change them add a field with last change time so you can get only the new and changed ones.