There are many things that could be causing the slowness. You have not stated if you wrote the application or if some 3rd party written it. It could be that the database is not well designed or not indexed in such a way to allow for quick returns. It could also be that the queries that retrieve information from the database are pulling more information than necessary (Think SELECT Field1, Field2 FROM TableName rather than SELECT * FROM TableName). Also, the queries that retrieve information should potentially take advantage of the WHERE clause in SQL to help filter down the number of results returned. The hardware that the application and database is sitting on may not be powerful enough to handle the requirements placed on it by this application and other applications installed on it.
On Jun 3, 6:17 am, "Anish V S" <[email protected]> wrote: > Dear Friends, > > 7 months back i have installed a payroll application in an office.Now it > seems very slow when accessing data from backend. The size of backend about 8 > gb in size. > > How can i make it fast? > > What are the possible reason of slow performance?
