Im using Go 11 and server 11 also Go 12 and server 12.

 

I understand comes to cellular connection that connecting to a database is painfully slow especially if your database is huge.  im wondering if anyone of you has accomplished a turn around that makes things faster.

 

I developed a database in the server that host products and inventory.  Also, developed a FMGo App that will pull information in that inventory.

 

The records/information I pull are the following

 

- Image (just 1 image) and is completely on a separate database so the main database does not slow down.  Its relational connection.

- Product ID which is a value list drop down on the main database.

- Sizes and count which is also relational.

 

so, it works but with the test that I am doing.  everyones complaint is... its just slow.  It's slow when the sizes are being pulled but when theres no size nor information.  It comes out a little faster than with a record.

 

3G connection is just really slow and I gave up on that.

 

Is there a better way in making this faster?  hosting the file to a faster service?  Or creating another database that will pull out just the information that I need?

 

thanks in advance

 

Things would be def. better if you'd use caching on the FileMaker Go-Client.

Have a look at GoZsync & MirrorSync