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