Hello all,
We are implementing a database using MS SQL 2000 w/sp1. We seem to be having a performance issue. The PowerBuilder 6.5 applications we use to interface are painting their windows with multiple objects slooooooow. For example, we have one window with 3 separate datawindow components and we can see each datawindow slowly paint into the window when it's opened. We tried this same scenerio with MS SQL 6.5 database and it ran fast!(we also experimented with MSSQL7 and it ran fast also). All indexes and relationships have been checked at the database and are ok. Any suggestions out there? Thanks in advance, Mike.
We are implementing a database using MS SQL 2000 w/sp1. We seem to be having a performance issue. The PowerBuilder 6.5 applications we use to interface are painting their windows with multiple objects slooooooow. For example, we have one window with 3 separate datawindow components and we can see each datawindow slowly paint into the window when it's opened. We tried this same scenerio with MS SQL 6.5 database and it ran fast!(we also experimented with MSSQL7 and it ran fast also). All indexes and relationships have been checked at the database and are ok. Any suggestions out there? Thanks in advance, Mike.