New answers tagged

1

This query takes about 30 seconds to run which is a bad experience. What actions have you taken to improve the performance of this query? Hiving the results off into a cache is just kicking this particular Problem's "can" further down the road. ... a query with lots of inner joins ... Lots of joins do not imply a poorly performing Query. Yes, ...


1

First the report could be out of date if the user hits the cache after updating data An update operation should also invalidate the cache. With proper invalidation, you'll always have up to date results. Second the first page load after the ttl expires will be slow. It depends on what you cache. If you cache the final result, this means indeed that you'll ...


0

I think there is no one-size-fits-all solution for this problem. There is a lot of factors which influences the to be chosen solution, like How many different clients / consumers do you have? 1.1) Less than then? 1.2) More than a thousand? Are these clients using your API in the same way? 2.1) Are they implementing the same functionality (just for different ...


6

Perspective Rub your eyes and look at what you are discussing: a WebApp and a Server that communicate across a network. That is literally two separate applications with a network interface. In fact you have just reinvented the Thick client. Just instead of installing it on Windows, and compiling it from C++ you are writing it in JavaScript and installing it ...


1

One likely reason to not allow uploads of SVG files is that they support embedded scripts. These could potentially be used for XSS or other nefarious purposes. Personally, I think it was a mistake to make this a feature of SVG for precisely that reason.


-1

What I know is, Picture contains pixels (stored information which doesn't need processing before showing up) contrary to vectors which are not just stored information of pixels but contains a way how to process to get image. This way of processing to get an image is not always preferred due to computation cost unless we need a scalable image (no quality ...


Top 50 recent answers are included