1
Database hanged due to concurrence
Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration issue? What should we check [...]
Answer Question
| August 11, 2008 5:40 PM
Database performance and tuning, SQL Server 2000, SQL Server database, Windows Server 2003
Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration issue? What should we check [...]
Answer Question
| August 11, 2008 5:40 PM
Database performance and tuning, SQL Server 2000, SQL Server database, Windows Server 2003
Internal vs Externa Stored Procedure Performance
Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there any diference in performance between internal vs external stored [...]
Answer Question
| May 4, 2010 2:18 AM
C#, Database performance and tuning, DB2/400, SQL stored procedures, Stored Procedures
Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there any diference in performance between internal vs external stored [...]
Answer Question
| May 4, 2010 2:18 AM
C#, Database performance and tuning, DB2/400, SQL stored procedures, Stored Procedures
Optimizing Query
Hi, I am having a table which is having around 170 Columns(Don’t blame me but my Developer) and there are only 989 records in the table.I created all sorts of Indexes but still the query (Select * from Table) takes almost 2 mins to display 989 records.I need all the columns to be displayed.Is there [...]
Answer Question
| July 4, 2008 11:30 AM
Database performance and tuning, Query optimization, SELECT statement
Hi, I am having a table which is having around 170 Columns(Don’t blame me but my Developer) and there are only 989 records in the table.I created all sorts of Indexes but still the query (Select * from Table) takes almost 2 mins to display 989 records.I need all the columns to be displayed.Is there [...]
Answer Question
| July 4, 2008 11:30 AM
Database performance and tuning, Query optimization, SELECT statement
How to optimize results coming from database
Sir, I hv created a software which searches for the information the user wants. If only one user is using database at a time then it gives response in milliseconds. But when at a time 10 or more than that start using it then throughput decreases. So how i should do optimization
Answer Question
| June 11, 2008 10:48 AM
Database performance and tuning, Java, MySQL
Sir, I hv created a software which searches for the information the user wants. If only one user is using database at a time then it gives response in milliseconds. But when at a time 10 or more than that start using it then throughput decreases. So how i should do optimization
Answer Question
| June 11, 2008 10:48 AM
Database performance and tuning, Java, MySQL
Storing Binary Data
I’ve been in the process of reviewing the pros and cons of storing binary data (e.g. image files) either in blob fields in a database (presumably MySQL) vs. the filesystem of a server. I’m aware there are some concerns of security, but I’m mainly interested in performance at present. I could easily ask you a [...]
Answer Question
| May 16, 2008 3:45 PM
Binary data, BLOB, Database, Database performance and tuning, MySQL
I’ve been in the process of reviewing the pros and cons of storing binary data (e.g. image files) either in blob fields in a database (presumably MySQL) vs. the filesystem of a server. I’m aware there are some concerns of security, but I’m mainly interested in performance at present. I could easily ask you a [...]
Answer Question
| May 16, 2008 3:45 PM
Binary data, BLOB, Database, Database performance and tuning, MySQL
1
