Database Problem
-
Hello Ihave a programe store about 40,000 record in database,and make report from them . but the programe work so slowly when I want to find last ID number. I use ODBC to connect to database. to get the last ID I use m_strFileter and m_strSort properties & Requery MethodRequery . wat can I do to get better performense ? (please show me a way to use database:confused: ) tnX Iman Ghasrfakhri
-
Hello Ihave a programe store about 40,000 record in database,and make report from them . but the programe work so slowly when I want to find last ID number. I use ODBC to connect to database. to get the last ID I use m_strFileter and m_strSort properties & Requery MethodRequery . wat can I do to get better performense ? (please show me a way to use database:confused: ) tnX Iman Ghasrfakhri
If your database is MS ACCESS you should use DAO instead of ODBC, that means CDaoDatabase and CDaoRecordset and not CDatabase and CRecordset. To my experience this is much more faster. Hope this helps. MS
-
Hello Ihave a programe store about 40,000 record in database,and make report from them . but the programe work so slowly when I want to find last ID number. I use ODBC to connect to database. to get the last ID I use m_strFileter and m_strSort properties & Requery MethodRequery . wat can I do to get better performense ? (please show me a way to use database:confused: ) tnX Iman Ghasrfakhri
The "last ID number" field must be indexed. The speed difference between ODBC and DAO, if any, is negligible.
A rich person is not the one who has the most, but the one that needs the least.