1. mathews rutto
  2. PowerBuilder
  3. Thursday, 20 June 2024 18:39 PM UTC

Hi,

I have publish my web app successful. I have a question, the client have more than 20k images that they need to be access via system. I have uploaded very few into the image folder. If i load more than 20k images will that make my application slow?

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 20 June 2024 18:54 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Mathews ;

  You also have a few other choices that would negate deploying any App images ...

Food for thought.  HTH

Regards .. Chris

Comment
  1. mathews rutto
  2. Thursday, 20 June 2024 19:44 PM UTC
Thank you for this, I will try it out.
  1. Helpful
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Thursday, 20 June 2024 18:52 PM UTC
  2. PowerBuilder
  3. # 1

"20k images"

 

I assume based on the title, that the 20 thousand are the documents that are being managed? 

If so, you need to figure out a way to manage them. You can build your own download service and store/update them on your own server, or use a blob/file  system from azure or aws or another provider.  

the uploaded images directory is mainly for things like application icons and maybe help videos.  Stuff that a developer would manage.

If the users want to create/upload a file they would not be able to do that. 

Comment
  1. mike S
  2. Thursday, 20 June 2024 19:49 PM UTC
if you are only retrieving them for display, then you have more options.



If you need to secure them, delete them, update them, and add new ones then you need to have a system in place to handle that.



you can use a dbms to do that, and it is probably a bit easier to do it that way. longer term it will be more expensive and seriously slow down backups. I recommend against that for a production application.



If you are using a cloud infrastructure such as azure or aws, then you will want to use the azure/aws blob storage service. storage costs are much lower than storing in a database, and have better/automatic backups etc. it is all rest api based.



if hosting on your own hardware, you can still use the blob services. but you can also write your own in c# to handle the uploads/deletes/retrieves and then just store them on the server. You have to figure out your own backups etc.



  1. Helpful
  1. mathews rutto
  2. Friday, 21 June 2024 02:09 AM UTC
Thank you.

Will you share a sample of how to go about with DBMS?
  1. Helpful
  1. mike S
  2. Friday, 21 June 2024 11:57 AM UTC
you use selectblob and updateblob sql statements to select and update a blob column where you store your files.

syntax is dependent on your database
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.