We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
SI - Site Forums : Silicon Investor - Welcome New SI Members!

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
Recommended by:
Eric L
Kirk ©
Smiling Bob
Terry Maloney
Zen Dollar Round
To: Ron who wrote (32587)9/16/2023 7:23:55 PM
From: SI Dmitry (code monkey)12 Recommendations  Read Replies (6) of 32694
Dear Ron,

There has been a longstanding an issue related to base64 encoded images being uploaded into our message database. Images need to be uploaded to our servers using the "image" icon, or pasted as a deep link to another site. Otherwise, they are not stored on our file server where they should be and are instead stored in our message database, take up ~30% more space then otherwise, and badly impacting query performance and slowing message search.

It is the reason certain member profiles take so long to load... that member had pasted a bunch of these images in their most recent message posts. This is really negatively affecting the performance of our site.

A user may not be aware when they paste into a message post that the image is a (massive) base64 encoded string. It really depends upon the format the images were served under on the site from which the image was copied. Most sites don't serve images base64 encoded, they serve them from a file server, like we do, in which case the pasted image is deep-linked to the same originating file server.

I'm working on a code update to clear out these base64 encoded images from our message database and that will prevent them from being pasted into message posts on SI going forward. When a member pastes such a message after this update, the image encoded in this manner simply won't be there. Again, base64 images are a minority of images posted as part of SI messages and most users will be unaffected.

After we complete this task, especially the database cleanup, the site will run much faster.

This has been an issue affecting site performance for a while.


Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext