In fact, when I took over this system, I think the company is completely complicated to earn money to earn customers. For a small county's toll system, the database can be used to use more good management SQL Server, but the company uses Oracle, because it is necessary to reduce costs, do the server is a Dell PowerEdge (TM) series teaches low grade, upgrade to 1G Memory is still more effective for 9i. Due to the original ERALCE is a version 7.3, directly upgrade to 9i, the first choice to solve the character set problem, by modifying the Prop $ table and OraHome90 attribute, finally introduced the original data into the new server. In order to improve system performance, the SQL statement is re-analyzed, and the regular operation is established, and the corresponding process and functions have been established on the server side. This system is C / S mode, the client is written with Delphi, optimizes the client program by explicitting the use of the Session and StoredPro controls, while in order to meet customer needs, modify and add some reporting features. Old Zhao Yu 04, winter
