Importing users

Permalink
For a project I currently need to import over 5000 users. Each user has a minimum of 30 attributes.

With the setattribute this will already go to a minimum of 150.000 queries. On my local machine the import already takes about 1.5 hour using the available concrete 5 functions only.

Eventually the file to import might go over 10.000+ users. The current host only allowed me to do 30.000 requests an hour. They upgraded it to 60.000 which is the max I could get.


Does anyone know a more efficient way of importing these kind of lists ?

 
frizzleb replied on at Permalink Reply
frizzleb
Why not query a large chunk of the table at once and handle the resulting array. I assume at the moment you are using a large number of individual queries to gather the data.

SELECT * FROM table

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.