By limbovski on
I've written a custom service to send information to DiOS for an iPhone App.
One requirement is to build a list of articles on my site consisting of title, thumbnail and published date.
I made a simple view to create this output but I cannot manipulate it successfully enough to easily extract the data I need and send it with my service.
So my solution was to to a db_query and get a resultset containing the title, thumbnail fid and published date.
Then I will query the database using field_file_load to get the filepath from the fid.
This results in 11 db queries.
1 transmission to the iphone
followed by 10 images loading.
I doubt this is efficient, any information or pointers would be great?
