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
