Current use of technology to request data server, every play a minor operation, input is not very convenient, delayed operation, but not for a long time, is there a better way or technology?

CodePudding user response:

And downloaded to a local search on the client

CodePudding user response:

LS,,, this is not the way, all these huge amounts of data search baidu, Google the somebody else is very fast, this with the client side doesn't matter too much, the aspects from the database, to make often search keyword index of what, I don't know my way around the database, had better go to SQL version of q,

CodePudding user response:

Thank you for the 3 l!!!!!!

CodePudding user response:

Server do a interface, cache common data, the user more frequent operation, do a few local cache can reduce the pressure of the server, after all, the general enterprise can't burn like Google baidu do server,

Didn't do only database, server, where speed is less than, database index, data volume is too big, do a table, the common data to other

Speed, if through the Internet connection, rent the host server is directly connected to the Internet to do good, local area network (LAN), more than 50 users best can thousands of signs in the net,

CodePudding user response:

Well well, to tell the truth, it is, when the amount of data is very big, the network is especially important,

reference 4 floor PPower response:

server do a interface, cache common data, user operation more frequently, do a few local cache can reduce the pressure of the server, after all, the general enterprise can't burn like Google baidu do server,

Didn't do only database, server, where speed is less than, database index, data volume is too big, do a table, the common data to other

Speed, if through the Internet connection, rent the host server is directly connected to the Internet to do good, local area network (LAN), more than 50 users best can thousands of signs in the net,

CodePudding user response:

Baidu their situation is not the same with you, the somebody else that is related to recent popular content, display is nothing more than the most matching up to ten topics. They are asking is not the accurate data, only related topics.
But you have to do is to reflect the database to match the content of all the collections you input. When data must be slow.

Think you to input in the OnChange judgment, if the goods are of first few characters under the selected data from the server to the local, don't first second character movement, wait until after the third word or action. After the local data set Filter.

Try it have any effect?

CodePudding user response:

Every time is in the table directly from the server search speed is certainly going to have a problem, if you want to do a large amount of data search tips, best service program, the server must do key data cache, the Memory cache, by the server according to the search results returned in the cache,
Upstairs said, other local byte handling strategy also want to consider,

CodePudding user response:

Performs a query database should automatically optimize query!

Drop-down matched normal situation is at the first click on the drop-down check list is empty, not empty execute query load data,

In the user name drop-down list, and then the input data, such a short period of time of database updates can ignore

Because it is in the name drop-down list when executed queries, so there will be no input to execute queries, speed should be acceptable

CodePudding user response:

Is to sum up, only when the highlighted a drop-down menu to perform a query to update the data in the drop-down list, because all don't repeat the data into the list, so by the edit box to match was completely can

For example, if the edit box is ComboBox:
Void __fastcall TForm1: : ComboBox1DropDown (TObject * Sender)
{
((TComboBox *) Sender) - & gt; The Items - & gt; The Clear ();//to empty the ComboBox control
//write data statement
}