我是继建立之后的。
MySQL server instance1 MySQL server instance2
在表一中,有一个单独的表格记录,分门别类。 我必须从每个方面检索数据,并显示在盖里的数据。
Here are the consideration to be made: 1) From each database instance only 1000 records needs to be got. 2) Merge these 1000 records and sort in ascending order by a default column. 3) Again from the merged records get only 1000 records to be shown in a Grid. 4) For the next 1000 records we should not show any of the earlier records which have been shown.
我所面临的主要问题是,如何独一无二地确定从单列记录中显示的最后一行。
I thought about doing it this way: 1) Get the rowid for each record from all the connection. But from two instances the rowid would be same then how would I identify which record is from which database? 2) Check for rowid and primary key combination. But if the client sets the primary key s auto-increment value as same on all the instance then we would not get a unique combination.
我要么没有东西,要么没有其他办法去做?
我正在利用亚行的链接连接数据库。
[SOLVED IT] Solved the problem by writing a small function which calculates and create a map for the number of records to be fetched from each connection for each iteration.
职业介绍会可以在此补充《守则》,因为它是IP客户。