I'm doing a medical project, mobile phone android, Datasnap mode, the service side with FDconnecton datasetprovider, client with clientdataset, when the doctor after logging in, a patient list, click a patient, the background will have a thread started to query the database, download all kinds of information, including some of the pictures, then I have a rotating figure interface will prompt in loading, until better jump another interface, problems come, for a long time, the execution of the background is too TM according to different patients have more than 20 seconds, don't know what a great god has good experience, logical processing, for example, database optimization, etc., can solve this kind of wait that long to enter the main interface of embarrassing

CodePudding user response:

Maybe you will find pictures will be very big, can tell you the picture, each only a few k with wifi environment, timely have a 30, 40, also don't want so long

CodePudding user response:

First for you this question, you can not find out, the background for so long because of the slow SQL execution, or the network too slow,
Second patient information display, it can be processing, text information to show first, will continue to receive the pictures if not receive, to receive after the show, not all information is accepted to complete the display, similar to the browser,

CodePudding user response:

refer to the second floor m617105 response:

first for you this question, you didn't find out, the background for so long because of the slow SQL execution, or the network too slow,
Second patient information display, it can be processing, text information to show first, will continue to receive the pictures if not receive, to receive after the show, not all information is accepted to complete the display, similar to the browser,

My patient information is displayed in the form of pictures, in addition to the images of information display is very soon

CodePudding user response:

reference qq_22983497 reply: 3/f

Quote: refer to the second floor m617105 response:

First for you this question, you can not find out, the background for so long because of the slow SQL execution, or the network too slow,
Second patient information display, it can be processing, text information to show first, will continue to receive the pictures if not receive, to receive after the show, not all information is accepted to complete the display, similar to the browser,

My patient information is displayed in the form of pictures, in addition to the images of information display is soon

To check what slow, SQL execution or network transmission,

CodePudding user response:

Now that is the result of a picture, that is stored in the database image path, pictures on the FTP server

CodePudding user response:

Your problem, I also meet, 40% of the total feeling is SQL database, network (60%),

CodePudding user response:

Another picture as far as possible let pixels smaller, transmission is quicker,

CodePudding user response:

It can be design interface that put the text in the front interface for display,

CodePudding user response:

Best is local have ACCESS, as the cache, repetitive data in ACCESS calls, difference data in SQL SERVER to download
Large amount of data, this is a natural problem, the algorithm how to solve?