KanedNUnable
Technical User
Good day to you all!
This is my first post on this forum, but I have done a great deal of browsing (thru this site & others) to try and find out more about my query before resorting to a post - unfortunately I can't really seem to get a clear idea of the route I need to take, so would really appreciate your help. Allow me to explain...
A friend & I are working on an asp website connected to a MySQL database. The site allows users to upload images (photos) then organise them into albums, add titles & notes etc - we have all this functionality working perfectly. The only issue is when many users are uploading at the same time it steals all the bandwidth & makes the site extremely slow.
One idea we had to resolve this was to have some kind of vb app which the user installs locally - they use this to select all the images they want from their hard drive, resize/compress where necessary, add titles/notes, select the destination album, then send the lot to their account on our site via ftp thus reducing bandwidth usage.
On our webserver, the images are stored in the users folder rather than the database, there is just a path to the file stored in the database. So for this idea to work, we would need an app to do the following:
Connect to the MySQL database with the user's registered id or email address, send each file across to the user's images folder, then create a record for each image in the database to store the file path, titles/notes and selected album parameters.
My question to all of you then, is this. Would a vb .exe file be the best way to achieve this, or are you aware of a much better/easier method which would allow users to do a transfer from their local machine to their folder on our webserver & write the details to the database? I must stress, I am not looking for coding help at this stage - I just want to hear the experts' opinions on how they would approach this issue!
I hope I have explained my query well enough, but am aware that the hardest part of finding a solution to your problem is explaining it in such a way that others understand it perfectly - so if you need any more detail to help form an opinion please just let me know.
Many thanks for your time.
This is my first post on this forum, but I have done a great deal of browsing (thru this site & others) to try and find out more about my query before resorting to a post - unfortunately I can't really seem to get a clear idea of the route I need to take, so would really appreciate your help. Allow me to explain...
A friend & I are working on an asp website connected to a MySQL database. The site allows users to upload images (photos) then organise them into albums, add titles & notes etc - we have all this functionality working perfectly. The only issue is when many users are uploading at the same time it steals all the bandwidth & makes the site extremely slow.
One idea we had to resolve this was to have some kind of vb app which the user installs locally - they use this to select all the images they want from their hard drive, resize/compress where necessary, add titles/notes, select the destination album, then send the lot to their account on our site via ftp thus reducing bandwidth usage.
On our webserver, the images are stored in the users folder rather than the database, there is just a path to the file stored in the database. So for this idea to work, we would need an app to do the following:
Connect to the MySQL database with the user's registered id or email address, send each file across to the user's images folder, then create a record for each image in the database to store the file path, titles/notes and selected album parameters.
My question to all of you then, is this. Would a vb .exe file be the best way to achieve this, or are you aware of a much better/easier method which would allow users to do a transfer from their local machine to their folder on our webserver & write the details to the database? I must stress, I am not looking for coding help at this stage - I just want to hear the experts' opinions on how they would approach this issue!
I hope I have explained my query well enough, but am aware that the hardest part of finding a solution to your problem is explaining it in such a way that others understand it perfectly - so if you need any more detail to help form an opinion please just let me know.
Many thanks for your time.
