So, nu habe ich das mal mit den Prepared Statements versucht, aber das Ergebnis ist noch schlechter :( knappe 120s...
for ($i=1; $i <= $xml->Values; $i++) {
$sql_eintrag = "INSERT INTO exp_analyse_messwerte
(id,
Time,
".$xml->{"ChannelInfo1"}->Name.",
".$xml->{"ChannelInfo2"}->Name.",
".$xml->{"ChannelInfo3"}->Name.",
".$xml->{"ChannelInfo4"}->Name.",
".$xml->{"ChannelInfo5"}->Name.",
".$xml->{"ChannelInfo6"}->Name.",
".$xml->{"ChannelInfo7"}->Name.",
".$xml->{"ChannelInfo8"}->Name.",
".$xml->{"ChannelInfo9"}->Name.",
".$xml->{"ChannelInfo10"}->Name.",
".$xml->{"ChannelInfo11"}->Name.",
".$xml->{"ChannelInfo12"}->Name.",
".$xml->{"ChannelInfo13"}->Name."
) VALUES
(:id, :Time, :ChannelInfo1, :ChannelInfo2, :ChannelInfo3, :ChannelInfo4
, :ChannelInfo5, :ChannelInfo6, :ChannelInfo7, :ChannelInfo8, :ChannelInfo9, :ChannelInfo10, :ChannelInfo11
, :ChannelInfo12, :ChannelInfo13)";
$stmt = $dbc->prepare($sql_eintrag);
$stmt->bindParam(':id', $id);
$stmt->bindParam(':Time', $xml->{"M$i"}->Time);
$stmt->bindParam(':ChannelInfo1', $xml->{"M$i"}->{"Ch1"});
$stmt->bindParam(':ChannelInfo2', $xml->{"M$i"}->{"Ch2"});
$stmt->bindParam(':ChannelInfo3', $xml->{"M$i"}->{"Ch3"});
$stmt->bindParam(':ChannelInfo4', $xml->{"M$i"}->{"Ch4"});
$stmt->bindParam(':ChannelInfo5', $xml->{"M$i"}->{"Ch5"});
$stmt->bindParam(':ChannelInfo6', $xml->{"M$i"}->{"Ch6"});
$stmt->bindParam(':ChannelInfo7', $xml->{"M$i"}->{"Ch7"});
$stmt->bindParam(':ChannelInfo8', $xml->{"M$i"}->{"Ch8"});
$stmt->bindParam(':ChannelInfo9', $xml->{"M$i"}->{"Ch9"});
$stmt->bindParam(':ChannelInfo10', $xml->{"M$i"}->{"Ch10"});
$stmt->bindParam(':ChannelInfo11', $xml->{"M$i"}->{"Ch11"});
$stmt->bindParam(':ChannelInfo12', $xml->{"M$i"}->{"Ch12"});
$stmt->bindParam(':ChannelInfo13', $xml->{"M$i"}->{"Ch13"});
$dbc->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
$stmt->execute();
}
Es wird wohl nicht besser...