LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-09-2006, 09:08 AM   #1
acristescu
LQ Newbie
 
Registered: Oct 2005
Posts: 4

Rep: Reputation: 0
Advice about sqlrelay or similar


Hello,

I'm analysing the possibility to use the sqlrelay software on a LAMP platform to take advantage of it's connection pooling features. I was curious to find out if someone else had used this in a production environment and if he/she cares to share some thoughts on the experience.

My second (related) question would be if there are any alternatives to sqlrelay. Some background info: Our problem comes from the fact that that the application requires us to receive a lot of reports from the client software through a PHP interface and update the MySQL database. The moment when these reports come in (they're all coming in the evening) the database is flooded with connection requests that only run a single "INSERT" query and then close, bringing the whole site to a grinding halt. mysql_pconnect seems to be inapropriate, as I don't want the whole site to use persistent connections and, firthermore, with this method the number of persistent connection does not grow/shrink depending on the number of requests.

Thanks
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
anything similar to WMI tijo.thomas Linux - General 2 02-23-2006 12:51 AM
Similar code for c vishalbutte Programming 5 01-17-2006 05:25 AM
dc++ or similar porio Linux - Software 3 04-27-2005 10:00 AM
something similar to flash? amoreno Linux - Software 0 02-08-2005 04:07 AM
anything similar to DNS2GO im1crazyassmofo Linux - General 2 02-09-2003 03:44 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:10 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration