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.Hello,

I dont 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

Multiple backup streams in SQL Server 2000

We have a 2TB Database on SQL Server 2000.
We make online backups every night of this database with the backup tool HP
Dataprotector 5.5
Does anyone know if it's possible to backup with more than one stream?
Backup windows are running out of time...
In dataprotector is an option "Concurrent streams" but this option is grade
out.
Thanks for your answers!!
Kind regards,
Rob van Acquoy
CTAC
Rob
I'm not familiar with that tool. Did you run BACKUP DATABASE command ....?
Do you have filegroup for the database?
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:7EB9CEEA-5B49-4D90-9FE5-F67D05E267BC@.microsoft.com...
> We have a 2TB Database on SQL Server 2000.
> We make online backups every night of this database with the backup tool
> HP
> Dataprotector 5.5
> Does anyone know if it's possible to backup with more than one stream?
> Backup windows are running out of time...
> In dataprotector is an option "Concurrent streams" but this option is
> grade
> out.
> Thanks for your answers!!
> Kind regards,
> Rob van Acquoy
> CTAC

Multiple backup streams in SQL Server 2000

We have a 2TB Database on SQL Server 2000.
We make online backups every night of this database with the backup tool HP
Dataprotector 5.5
Does anyone know if it's possible to backup with more than one stream'
Backup windows are running out of time...
In dataprotector is an option "Concurrent streams" but this option is grade
out.
Thanks for your answers!!
Kind regards,
Rob van Acquoy
CTACRob
I'm not familiar with that tool. Did you run BACKUP DATABASE command ....?
Do you have filegroup for the database?
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:7EB9CEEA-5B49-4D90-9FE5-F67D05E267BC@.microsoft.com...
> We have a 2TB Database on SQL Server 2000.
> We make online backups every night of this database with the backup tool
> HP
> Dataprotector 5.5
> Does anyone know if it's possible to backup with more than one stream'
> Backup windows are running out of time...
> In dataprotector is an option "Concurrent streams" but this option is
> grade
> out.
> Thanks for your answers!!
> Kind regards,
> Rob van Acquoy
> CTAC

Multiple backup streams in SQL Server 2000

We have a 2TB Database on SQL Server 2000.
We make online backups every night of this database with the backup tool HP
Dataprotector 5.5
Does anyone know if it's possible to backup with more than one stream'
Backup windows are running out of time...
In dataprotector is an option "Concurrent streams" but this option is grade
out.
Thanks for your answers!!
Kind regards,
Rob van Acquoy
CTACRob
I'm not familiar with that tool. Did you run BACKUP DATABASE command ....?
Do you have filegroup for the database?
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:7EB9CEEA-5B49-4D90-9FE5-F67D05E267BC@.microsoft.com...
> We have a 2TB Database on SQL Server 2000.
> We make online backups every night of this database with the backup tool
> HP
> Dataprotector 5.5
> Does anyone know if it's possible to backup with more than one stream'
> Backup windows are running out of time...
> In dataprotector is an option "Concurrent streams" but this option is
> grade
> out.
> Thanks for your answers!!
> Kind regards,
> Rob van Acquoy
> CTAC

Multiple authentication methods in scale-out deployment

Will SSRS 2008 support multiple authentication methods in a scale-out deployment (intranet / extranet scenario)? Books Online (July CTP) seems inconsistent in addressing this.

In the entry Server Architecture (Reporting Services) BOL states:

If your deployment requires multiple authentication providers, you can configure a scale-out deployment. For more information, see Planning for Scale-Out Deployment (Reporting Services).

When forwarding to the indicated link Planning for Scale-Out Deployment (Reporting Services), BOL states:

Report server instances in a scale-out deployment must have the same type of authentication extension. If you created a custom authentication extension, you must deploy and use that extension on all nodes.

Because of this restriction, you cannot configure a scale-out deployment to support simultaneous intranet and extranet access to the same report server database through separate report server instances where each instance is configured for different authentication types and authorization rules.

Which is it?

Regards,

Scott

It should be the second one (not supported). I will forward your feedback to the documentation folks.

Multiple authentication providers is under consideration for a post-2008 release.

Multiple authentication methods in scale-out deployment

Will SSRS 2008 support multiple authentication methods in a scale-out deployment (intranet / extranet scenario)? Books Online (July CTP) seems inconsistent in addressing this.

In the entry Server Architecture (Reporting Services) BOL states:

If your deployment requires multiple authentication providers, you can configure a scale-out deployment. For more information, see Planning for Scale-Out Deployment (Reporting Services).

When forwarding to the indicated link Planning for Scale-Out Deployment (Reporting Services), BOL states:

Report server instances in a scale-out deployment must have the same type of authentication extension. If you created a custom authentication extension, you must deploy and use that extension on all nodes.

Because of this restriction, you cannot configure a scale-out deployment to support simultaneous intranet and extranet access to the same report server database through separate report server instances where each instance is configured for different authentication types and authorization rules.

Which is it?

Regards,

Scott

It should be the second one (not supported). I will forward your feedback to the documentation folks.

Multiple authentication providers is under consideration for a post-2008 release.