1 Reply Latest reply on Jul 14, 2004 10:16 PM by genman

    slow insertion to MQ

    verlin123

      Hi,
      We've been trying to insert 100K messages to MQ but insertion drastically slowed down when queue depth reached 30K+. At first we tried using hsqldb, then switched to postgresql but the performance didn't improve. We tried to insert directly to the tables(using java/jdbc), there was no problem in insertion speed(7seconds per 10K records).
      What could we do to improve the speed and performance of the MQ's? Any suggestions?
      Thanks