I've developed an application using VB6.0 and Oracle8i. The data resides on Oracle server and 25 users access this data through VB interface and each of them have Oracle8i Client installed at their end. Initially when there are less no.of records in a table the data access speed is pretty good, but as it increases to few thousands the speed of data access reduces tremendously. FYI, let me tell u that the data is displayed in DataGrid.
Can anyone tell me how to retain the speed even if the size of table(s)