-I have no idea

-Try using HPL to load your datafiles. You can even use HPL in a shell
script and it will be incredibility fast.

-How often do you reboot your SQL Server machines?

-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of
zackary.evans@gmail.com
Sent: Thursday, June 08, 2006 10:19 AM
To: informix-list@iiug.org
Subject: Easy INFORMIX questions

I am very new to informix so be kind.

- Do stored procs have a procompiled/cached query plan in informix? If
you have any links discussing it would be very helpful.
- Does informix have anything similar to DTS packages in MS SQL Server
for doing optimized nightly loads of datafiles? Currently we are using
some incredibily inefficient shell script or compiled external load
program and it is causing major problems holding locks and taking
several hours to complete (i could do this load in SQL Server in under
and hour)

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

I don't know how often we reboot SQL machines, I am just a developer
not a DBA.

Does the HPL handle microsoft excel files? I am guessing not but hoping
it does.


Hamilton, Jerry wrote:
> -I have no idea
>
> -Try using HPL to load your datafiles. You can even use HPL in a shell
> script and it will be incredibility fast.
>
> -How often do you reboot your SQL Server machines?
>
> -----Original Message-----
> From: informix-list-bounces@iiug.org
> [mailto:informix-list-bounces@iiug.org] On Behalf Of
> zackary.evans@gmail.com
> Sent: Thursday, June 08, 2006 10:19 AM
> To: informix-list@iiug.org
> Subject: Easy INFORMIX questions
>
> I am very new to informix so be kind.
>
> - Do stored procs have a procompiled/cached query plan in informix? If
> you have any links discussing it would be very helpful.
> - Does informix have anything similar to DTS packages in MS SQL Server
> for doing optimized nightly loads of datafiles? Currently we are using
> some incredibily inefficient shell script or compiled external load
> program and it is causing major problems holding locks and taking
> several hours to complete (i could do this load in SQL Server in under
> and hour)
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list