System in an open interface, very slow (or even some time before the big white), article about 10 w this table data, at the same time online users have 7, 8, 10 people
Began to worry about is the network problems, found that after add bandwidth hit 10 m or slow,
Everybody to help negotiate what will cause this kind of situation and the countermeasure to deal with,

CodePudding user response:

I depend, article one hundred thousand of the data you retrieve out immediately,
This slow just strange,
Do you think can set retrieve conditions, to reduce the amount of data,

CodePudding user response:

How do you retrieve data, you can retrieve the data by means of retrieve parameters with,

CodePudding user response:

If the data is very large, so suggest use shareobject open new thread to load data

CodePudding user response:

refer to the original poster imti_cg response:

system in an open interface, very slow (or even some time before the big white), article about 10 w this table data, at the same time online users have 7, 8, 10 people
Began to worry about is the network problems, found that after add bandwidth hit 10 m or slow,
Everybody to help negotiate what will cause this kind of situation and the countermeasure to deal with,

You should be on DW filtered again displayed.

Parameter is set retrieve ().

CodePudding user response:

10 m bandwidth, it seems remote access, if it is remote, it is best to make it a web service (can use easerver or webservice), on the server to retrieve data, compression and then spread to the client, in addition, if it is not necessary, may consider the paging query,

CodePudding user response:

1, completes the index
2, add parameters, to reduce the retrieval scope, reduce the amount of data returned; Adding the date range, ha ha
3, such as paging, query, such as one-time return 2 k record

CodePudding user response:

Mark...

CodePudding user response:

Ha ha, demand change, no one who wants to look at, one hundred thousand data of acceptance in the twenty or so commonly, can use the SQL query to page shows that can check my previous post ~ ~

CodePudding user response:

Article one hundred thousand the big data?
Reason:
1) do you use the associative table, SQL can optimize
2) if the oracle, need to refresh database index and the number of records
3) expand the table space, can consider the table partitioning
4) according to the condition, the data filter

CodePudding user response:

When PB DW, display data, to a certain amount of data (such as YiLiangWanTiao, of course, also see you the number of columns), a sharp drop in performance.

Generally, very few really have tens of thousands of users will require a see article data. Most of the time, needs to understand very well.

1. Modify your data display mode.
2. If you really don't want to modify, and RETRIEVE, dw_1. Setredraw (false), finish set back, will be faster.

CodePudding user response:

Article 10 W, the customer needn't one-time see article 10 W

CodePudding user response:

Learn......

CodePudding user response:

Can Top 1000 or Top 5000, and so on, or allow the user to select a date range, on the date in the data filtering out!

CodePudding user response:

SQL code optimization,

CodePudding user response:

3 4 floor positive solutions

CodePudding user response:

Article 10 w the speed of data retrieval statement is no problem as long as your retrieval are generally not slow, but the dw display speed is very slow, suggest or paging display

CodePudding user response:

A parameter retrieveASNeed DW, you try this. How to use, can refer to the help of PB.
Effect is a query within the current size of the DW can display the data. Then scroll vertical scroll bar, query the data on the next page again.

CodePudding user response:

1. If it is remote, can consider to filter, index decrease the number of direct retrieval of records;
2. Set the local database, the commonly used query localization, reduces the remote network time delay;

CodePudding user response:

What is your pb version?
Anyway I met pb12 are slow, and pb9 quickly, up to now how to solve,

CodePudding user response:

1. Shareobject background load
2. Paging

CodePudding user response:

The building Lord zha don't show up, whether the server is not to force ah