in reply to Inserting large chunks of data into MySQL
To avoid that (and to boost performance) use placeholders instead:
my $sth = $dbh->prepare("INSERT INTO ques(username, userque, ...) VALU +ES (?, ?, ...)"); foreach my $t (split '~', $txtque){ $sth->execute($usernamenow, $t, ...); }
|
|---|