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
MySQL Stored Procedures with Parameters in Crystal Reports 9???
Hi, am using Crystal Reports 9 and the MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won’t accept this stored procedure and cites ‘Incorrect Number of Arguments; expected 1, got 0′. Im pretty new to MySQL and perhaps I shouldn’t be creating stored procs the way I do: CREATE [...]
Answer Question
| May 20, 2008 11:10 AM
Crystal Reports 9, MySQL, MySQL Stored Procedures, Parameter Stored Procedures, Stored Procedures
Hi, am using Crystal Reports 9 and the MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won’t accept this stored procedure and cites ‘Incorrect Number of Arguments; expected 1, got 0′. Im pretty new to MySQL and perhaps I shouldn’t be creating stored procs the way I do: CREATE [...]
Answer Question
| May 20, 2008 11:10 AM
Crystal Reports 9, MySQL, MySQL Stored Procedures, Parameter Stored Procedures, Stored Procedures
MySQL Stored Procedures in Crystal Reports
Hi, am using Crystal Reports 9 and MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won’t accept this stored procedure and cites ‘Incorrect Number of Arguments; expected 1, got 0′. Im pretty new to MySQL and perhaps I shouldn’t be creating stored procs the way I do: CREATE DEFINER=`admin`@`localhost` [...]
Answer Question
| May 8, 2008 11:18 AM
Crystal Reports, Crystal Reports 9, MySQL, MySQL Stored Procedures
Hi, am using Crystal Reports 9 and MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won’t accept this stored procedure and cites ‘Incorrect Number of Arguments; expected 1, got 0′. Im pretty new to MySQL and perhaps I shouldn’t be creating stored procs the way I do: CREATE DEFINER=`admin`@`localhost` [...]
Answer Question
| May 8, 2008 11:18 AM
Crystal Reports, Crystal Reports 9, MySQL, MySQL Stored Procedures
MySql Query
Hi Gurus i have a problem in MYSql Query Browwser there is a table “jiuser” in “jasperserver” database. this table has a column “username”. there is another table ” jiresourcefolder” in the “jasperserver” database. this table has a column “uri”. now i wana find out which user can access which uri. how to find it [...]
Answer Question
| April 8, 2008 11:12 AM
Database, JasperServer, Java, MySQL, Open source, SQL, SQL Query
Hi Gurus i have a problem in MYSql Query Browwser there is a table “jiuser” in “jasperserver” database. this table has a column “username”. there is another table ” jiresourcefolder” in the “jasperserver” database. this table has a column “uri”. now i wana find out which user can access which uri. how to find it [...]
Answer Question
| April 8, 2008 11:12 AM
Database, JasperServer, Java, MySQL, Open source, SQL, SQL Query
Running different versions of MySql on same machine?
Is it possible to run different versions of MySql on the same server machine?
Answer Question
| March 19, 2008 7:37 PM
Database, MySQL
Is it possible to run different versions of MySql on the same server machine?
Answer Question
| March 19, 2008 7:37 PM
Database, MySQL
Is there a server running on localhost: 3306?
Has anyone seen this error before? We’ve got a Windows 2003 Standard Server running MySql 5.x.x, with ColdFusion MX 7.x.x. Everytime we try to add a new MySql DSN Connection we get this error: Connection verification failed for data source: cudefault java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? The root [...]
Answer Question
| March 19, 2008 5:24 PM
ColdFusion, java.sql.SQLException, MySQL
Has anyone seen this error before? We’ve got a Windows 2003 Standard Server running MySql 5.x.x, with ColdFusion MX 7.x.x. Everytime we try to add a new MySql DSN Connection we get this error: Connection verification failed for data source: cudefault java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? The root [...]
Answer Question
| March 19, 2008 5:24 PM
ColdFusion, java.sql.SQLException, MySQL
how to compare 2 dates == x day and delete the file
hi, do any one know how to compare the 2 dates.comparing today’s and the file created date using mysql and c# here is my program but i am stuck string ConnectionString = “server=localhost;user id=name;password;persist security info=True;database=name of database;”; using (MySqlConnection conn = new MySqlConnection(ConnectionString)) { MySqlCommand cmd = new MySqlCommand(); conn.Open(); if (conn.State == ConnectionState.Open) [...]
Answer Question
| March 13, 2008 9:26 AM
C, MySQL
hi, do any one know how to compare the 2 dates.comparing today’s and the file created date using mysql and c# here is my program but i am stuck string ConnectionString = “server=localhost;user id=name;password;persist security info=True;database=name of database;”; using (MySqlConnection conn = new MySqlConnection(ConnectionString)) { MySqlCommand cmd = new MySqlCommand(); conn.Open(); if (conn.State == ConnectionState.Open) [...]
Answer Question
| March 13, 2008 9:26 AM
C, MySQL
how do i display session id on the web
hi, I am doing a login page with mysql and asp.net/c#. I would like the program to run in the following sequence. 1. the user login 2. the login page will search through mysql database, 3. when it is Authenticate, it will allow the user to access. my concern now is how to you use [...]
Answer Question
| March 10, 2008 9:38 AM
ASP.NET, C, MySQL
hi, I am doing a login page with mysql and asp.net/c#. I would like the program to run in the following sequence. 1. the user login 2. the login page will search through mysql database, 3. when it is Authenticate, it will allow the user to access. my concern now is how to you use [...]
Answer Question
| March 10, 2008 9:38 AM
ASP.NET, C, MySQL
Membership login with mysql
hi, i doing a login program which will be using mysql. I would like to how do i do that, I have done a little but i am stuck half way can anyone help? protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { MySqlConnection conDatabase = new MySqlConnection(“Server=localhost;Persist Security Info=no;User ID=Administrator”); MySqlConnection cnnVideos = new MySqlConnection(“Network Address=localhost;” [...]
Answer Question
| February 21, 2008 1:36 AM
ASP.NET, C, MySQL
hi, i doing a login program which will be using mysql. I would like to how do i do that, I have done a little but i am stuck half way can anyone help? protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { MySqlConnection conDatabase = new MySqlConnection(“Server=localhost;Persist Security Info=no;User ID=Administrator”); MySqlConnection cnnVideos = new MySqlConnection(“Network Address=localhost;” [...]
Answer Question
| February 21, 2008 1:36 AM
ASP.NET, C, MySQL
MYSQL/PHP based CMS (Mambo,Joomla) on the 400.
Has anyone setup one of the MYSQL/PHP based CMS (Mambo,Joomla) on the 400 yet? I use these CMS on regular Apache 2.0 servers with MYSQL 5.0 & PHP 4+ These CMS are very flexible and adaptable and I would like to use on the 400.
Answer Question
| February 14, 2008 11:08 PM
AS/400, CMS, Joomla, MAMBO, MySQL, PHP
Has anyone setup one of the MYSQL/PHP based CMS (Mambo,Joomla) on the 400 yet? I use these CMS on regular Apache 2.0 servers with MYSQL 5.0 & PHP 4+ These CMS are very flexible and adaptable and I would like to use on the 400.
Answer Question
| February 14, 2008 11:08 PM
AS/400, CMS, Joomla, MAMBO, MySQL, PHP
Access to MySQL – How hard is this going to be?
I’ve just taken on a client who has been building his databases in MS Access for 14 years. He wants to put a significant amount of this data into an online MySQL application. I know it can be done, and I’ve agreed to help him do it. Does anyone have a feel for what it [...]
Answer Question
| February 20, 2008 11:06 PM
Data migration, Microsoft Access, MySQL
I’ve just taken on a client who has been building his databases in MS Access for 14 years. He wants to put a significant amount of this data into an online MySQL application. I know it can be done, and I’ve agreed to help him do it. Does anyone have a feel for what it [...]
Answer Question
| February 20, 2008 11:06 PM
Data migration, Microsoft Access, MySQL
Creating forms with PHP and MySQL
Using PHP and MySQL, I am trying to create a table form which can input multiple data within the form. When the space row provided is not enough, I want to add in another function which can help add rows in the same table. How can I do this?
Answer Question
| March 16, 2010 5:45 PM
Development, Linux, MySQL, PHP
Using PHP and MySQL, I am trying to create a table form which can input multiple data within the form. When the space row provided is not enough, I want to add in another function which can help add rows in the same table. How can I do this?
Answer Question
| March 16, 2010 5:45 PM
Development, Linux, MySQL, PHP
Need your help with sql joins
Hi there, I have two tables named articles and writers. articles table looks like this : article_id writer_id translator_id article_text writers table looks like this: id writer_name date_joined A few of the articles could be translated but mostly self written articles. The writer_id and translator_id are from writers table. A writer could write an article [...]
Answer Question
| January 22, 2008 8:33 PM
MySQL
Hi there, I have two tables named articles and writers. articles table looks like this : article_id writer_id translator_id article_text writers table looks like this: id writer_name date_joined A few of the articles could be translated but mostly self written articles. The writer_id and translator_id are from writers table. A writer could write an article [...]
Answer Question
| January 22, 2008 8:33 PM
MySQL
programming for PHP and MySQL
how do i get my login page to direct a user to an appropriate page depending on user username, password and domain previlidges from a database. am using php and mysql
Answer Question
| January 15, 2008 7:58 AM
MySQL, PHP
how do i get my login page to direct a user to an appropriate page depending on user username, password and domain previlidges from a database. am using php and mysql
Answer Question
| January 15, 2008 7:58 AM
MySQL, PHP
Database
What is the difference between Hsql and Mysql?
Answer Question
| January 3, 2008 6:54 AM
HSQL, MySQL
What is the difference between Hsql and Mysql?
Answer Question
| January 3, 2008 6:54 AM
HSQL, MySQL
design a web database application
i want to design a web database application to compile undergraduates results using php and MySql. can i get a worked example?
Answer Question
| January 16, 2008 11:51 AM
MySQL, PHP
i want to design a web database application to compile undergraduates results using php and MySql. can i get a worked example?
Answer Question
| January 16, 2008 11:51 AM
MySQL, PHP
C#.Net
Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend? Please forward on [...]
Answer Question
| March 10, 2008 3:58 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools
Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend? Please forward on [...]
Answer Question
| March 10, 2008 3:58 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools
Correlated Subquery – NOT EXIST
Hi - I’m trying to add a not exist subquery in my where statement and have several other joins ahead of it. I’m having difficulty determining where to put the NOT EXIST as the subquery is named as a column – ie blue.color in (select * from …..). Where would I put the NOT EXIST [...]
Answer Question
| February 22, 2007 3:00 PM
MySQL, SQL, SQL Server
Hi - I’m trying to add a not exist subquery in my where statement and have several other joins ahead of it. I’m having difficulty determining where to put the NOT EXIST as the subquery is named as a column – ie blue.color in (select * from …..). Where would I put the NOT EXIST [...]
Answer Question
| February 22, 2007 3:00 PM
MySQL, SQL, SQL Server
iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB – real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files available [...]
Answer Question
| October 14, 2010 10:35 AM
Access, ASP.NET, C, Database, DataCenter, DataManagement, DB2, DB2 Universal Database, Desktops, ESRI, HEAT, HTML, Management, Microsoft Office, Microsoft Windows, MySQL, Oracle, OS, PC/Windows Connectivity, Perl, PHP, Security, Servers, SQL Server, T-SQL, VB.NET, VBScript, Web site design & management, WebSphere Studio, XML
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB – real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files available [...]
Answer Question
| October 14, 2010 10:35 AM
Access, ASP.NET, C, Database, DataCenter, DataManagement, DB2, DB2 Universal Database, Desktops, ESRI, HEAT, HTML, Management, Microsoft Office, Microsoft Windows, MySQL, Oracle, OS, PC/Windows Connectivity, Perl, PHP, Security, Servers, SQL Server, T-SQL, VB.NET, VBScript, Web site design & management, WebSphere Studio, XML
