New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
Depends how much effort you put into minimization I guess...
Developer sets Windows 11 record by running it on just 184MB of RAM
https://www.techspot.com/news/106186-developer-sets-new-windows-11-record-running-184mb.html
I use standard microsoft iso installation and disable few unnecessary services.
No tiny install crap. Such thing breaks whenever windows update is applied.
I like to keep it as it was in standard iso. Peace of mind and no security risk, in my limited wisdom.
I like this too. When the installation templates provide a Windows image, I usually download the ISO file from the official website after installation and reinstall it, which feels very comfortable.
Where is VirBot tokyo madness sir?
I noticed a website: https://www.chkaja.com/bf.php, which tracks virbot's sales. You can view past BF sale records. Japan VPS prices went as low as $8 per year.
LOL！
Hard to make a choice like these
buy it for a year, and measure the total downtime experienced (if any), that will influence your decision for the following year.
not saying good or bad, but statistics dont lie.
That's a RAM steal of some kind.
The full uncropped size was 512 MB
Offer #2242
SKU: RYZEN SKU# V0M-XD
4 cores
4608MB RAM
130GB NVMe Storage
1 IPv4
12800GB Bandwidth
LOS ANGELES, CA
$37.20 per YEAR
Now $33.48
1 hour, 35 minutes left
$21.53 after 10% discount coupon
Update — price reduced to $23.20
$20.88 after 10% coupon
Update — price reduced to $21.53
$19.38 after 10% coupon
what is the 10% coupon...? lol
Here is a screenshot on that $18/year vps
running Windows 11 Enterprise, SQL Server database server and SSMS client on the same VPS
That is pushing the VPS to the limit since VPS has only 2.5 GB memory
Similar setup is
not possible on Linux based OSrunning SQL Server and trying to retrieve 5 million rowsguys someone give me a tldr im too lazy to read 5 pages, what are we talking about now? virmass bad or what
tldr .. Virmache is untrustworthy any money you give him be prepared to lose same with your service with little explanation
seems like 90% of companies?
wasn't this the company where the owner of the company posted pictures of himself in a fursuit wearing diapers? It was either virmach, or some summer host.
Similar setup is not possible on Linux based OS running SQL Server and trying to retrieve 5 million rows
You know that frontend will be using cursors and only fetching what you can see on the screen, right? If you have reasonable indices created the initial query should be doing almost no work whatever database you use.
How isn't this possible on a Linux based OS when you can actually remove the GUI overhead and just remotely access the database?...
SSMS (db client) and SQL Server DB Server on the same vps …. And front end is indeed pulling all rows
of course, this is not a representative of prod query, but my point was to highlight that vps is powerful enough to run SQL queries that bring lot of data.
Try something similar on Linux desktop on a vps with 2.5 gb memory.
I will be happy to be proven wrong.
I can run similar setup on 1gb vps if database queries are being run on a remote machine.
holy shit what????? I really don't think that'd be Virmach but now I wanna know what host you're talking about, that's funny as fuck
No need to run any 'desktop' to access a MYSQL server. Half your RAM and CPU are likely being eaten by Windows GUI leaving less resources for computing. Think through what you are saying when you likely know the difference in resource usage for both desktop environments.
Most tests point to Linux being slightly quicker than Windows for this use case scenario. I trust you've done your research already.
There are smart client, does not render the rows outside viewport, it means, it does not render all the rows except the one shown on view. I have myself wrote as many views like this in VC++/MFC, later .NET/Winforms/WPF, then in React/HTML5 etc.
of course, smart clients are pretty common.
My post was in response to your post with respect to large query set ... please read in that context
https://lowendtalk.com/discussion/comment/4266300/#Comment_4266300
As I mentioned in post earlier, my point was to highlight that vps is powerful enough to return large set.
Here is similar setup on a tiny VPS
1 vCore and just 1 GB memory
Windows RDP + SQL Server + SSMS (db client) on same tiny server
ps - minimum 2gb memory is needed to install SQL Server DB on a linux machine
As I replied to you, it's NOT returning the whole set, because the GUI will be using the cursor API, so it will do a fresh query every time the window is shown and the database engine will only return the rows requested.
Try taking any programming language, connect to the same database and do the same query and see how long it takes to fetch the entire dataset back.
EDIT: Maybe I shouldn't be so argumentative, as there's a chance it might actually be fetching all rows. Usually though, GUI tools especially ones shipped with the SQL engine, are usually clever enough to optimise this by using the cursor API.
@ralf
Please look at this screenshot
100k rows took only 1 second
2 million rows took 11 seconds
The SSMS gui window is showing only 25 rows in the visible window
Anyway, as for Linux stuff. I'm going to "cheat" and use sqlite3 because it's really fast. Also, I only have one machine with mariadb on and it's doing something important and I don't want to set up a new instance. I also don't have any GUI tools for either sqlite3 or mariadb because I do everything command line.
I've no idea about your schema, but here's a query on that does something similar one of my databases in Linux done from the command line. I've changed the table name and column names manually, but none of these fields are indexed as they are essentially random properties of the records (b can also be null):
That's actually returning quite a lot of columns, let's try something smaller:
And here's what some of that data looks like:
water is wet