关于PDA数据慢问题，解决方案

1.硬件问题，可以通过购买硬件来提升程序的性能2.程序优化，去掉不是必须的代码，在不影响功能的情况下，提供性能3.数据表分化，分而化解。附上代码for (int i = 1; i < 10; i++)            {               //创建表代码            }

            /**             * 对料品进行分表 A-Z             */            for (int i = 65; i < 91; i++)            {               //..            }查询代码Char[] CodeM = (code.Substring(0, 1)).ToCharArray();            #region            string sql = "";            switch (CodeM[0])            {                case 'X':                case 'Y':                case 'Z':                    sql = "";                    break;                case 'P':                    sql=SelctP(code);                    break;                default:                    sql = "";                    break;            }            #endregion            string name = "";   //联库操作   }

 private string SelctP(string code)        {            string sqlstr = "";            string itemCode = code.Substring(0, 4);            if (code.Substring(0, 5).Equals("P4250"))            {                sqlstr = "";            }            else if (itemCode.Equals("P425"))                sqlstr = "";            else                sqlstr = "";            return sqlstr;        }