Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    1

    Unanswered: multiple insert delays

    I am trying to work on a java application that does multiple inserts to the informix database. The data is actually obtained from an online screen. I see that the performance is very poor when ever the user enteres more than 20 records. This is caused because of the 20 inserts performed with in the program. Is there anyway I could do this in one insert.

    I know that the bulk insert could be done using INSERT into ..select from.
    I cannot use this as I do not have my data in a table.

    Please advice.

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    Hello,

    I don´t know Informix very well, but when you want to insert 20 records in a database, the execution time must be less than 1 second. For example 500-1000 insert on an oracle database will take 1 second (depends on the machine and network and so on). This is the execution time that we reach in various projects.

    So - there must be a problem with your application or your network. Did you trace your application ? So that you can see what is happening ?

    Greetings
    Manfred Peter
    (Alligator Company)
    http://www.alligatorsql.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •