C#

Mogaambo wrote:

Well first of all thanks for your valuable suggestions but as you are MVP and you say

Colin Angus Mackay wrote:
I give up.

But Something for you.

Mogaambo wrote:

more fast then previous one

Mogaambo wrote:

Yes I did , but check yourself what answers i received, are they fruitful


no no no no

George_George wrote:

Are there any good design patterns for such issues?

George_George wrote:

I can create many threads on client side to get data from server as fast as possible

George_George wrote:

Please trust me I understand multi-threading, and also IOCP concept.

George_George wrote:

You mean what is not going to happen?

George_George wrote:

do you have any related materials to recommend?

George_George wrote:

But what I am asking is the best practices for data access patterns

George_George wrote:

- I want to let client side library to start multiple threads to work efficiently to request for multiple content at the same time other than a single thread pattern;
- But I do not want to hit the server too hard and I also do not want to the library to consume too much resources (memory/threads) on client side to block other work of the client. The library is delivered as a DLL, so loaded into client side process, and will compete for resources of the same process.

Are there any good design patterns for such issues?

private DataTable GenDT(string strSelect)
{
    DataTable _dt = new DataTable();
    new OracleDataAdapter(strSelect, oraCONNECTION).Fill(_dt);
    return _dt;
}

private void Populate_treeView1()
{
    DataTable dt1, dt2, dt3;
    int ID;
    string sep, seperator;
    sep = ":";

    #region Table1
    dt1 = GenDT("SELECT * FROM Table1");
    for (int x = 0; x < dt1.Rows.Count; x++)
    {
        ID = int.Parse(dt1.Rows[x]["ID"].ToString());
        Name = dt1.Rows[x]["NAME"].ToString();

        treeView1.Nodes.Add(Name + sep + ID.ToString(), Name);

        #region Table2
        dt2 = GenDT("SELECT * FROM Table2 WHERE T2_Table1_ID = " + ID);
        for (int y = 0; y < dt2.Rows.Count; y++)
        {
            ID = int.Parse(dt2.Rows[y]["ID"].ToString());
            Name = dt2.Rows[y]["NAME"].ToString();

            treeView1.Nodes[x].Nodes.Add(Name + sep + ID.ToString(), Name);

            #region Table3
            dt3 = GenDT("SELECT * FROM Table3 WHERE T3_Table2_ID = " + ID);
            for (int z = 0; z < dt3.Rows.Count; z++)
            {
                ID = int.Parse(dt3.Rows[z]["ID"].ToString());
                Name = dt3.Rows[z]["NAME"].ToString();

                treeView1.Nodes[x].Nodes[y].Nodes.Add(Name + sep + ID.ToString(), Name);
            }
            #endregion
        }
        #endregion
    }
    #endregion

    treeView1.ExpandAll();
}