Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: Database input speed question

by deliria (Chaplain)
on Jul 31, 2003 at 19:43 UTC ( [id://279750]=note: print w/replies, xml ) Need Help??


in reply to Database input speed question

If you are using MySQL and need to do some processing which can't be handled by a bulk importer, you could use

INSERT DELAYED INTO table (columns) VALUES ( 'values' )

This will cause the client to abandon the query after it's send to the server and thereby speeding things up. If you don't need to get the return values, or for example an auto-increment number, this might be a way to go.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://279750]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2024-04-23 06:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found