Not all versions of Windows run 32bit apps. Windows PE (Preinstallation Environment) for example, can’t. And I have a need to do things in PE, and I don’t want to have to deal with Visual Studio if I don’t have to.
I highly recommend this.
https://schneegans.de/windows/unattend-generator/
I only found it about a month ago after spending years to find something like this.
Basically configure what you want your pc to be like when its installed.
Copy the xml file to the usb, then boot onto it and it install windows fully configured in about 11mins!
Need to fully wipe the hard drive like the w2k/xp option? Just delete all instances of the word QUICK.
Can install your own software, run your own scripts and more…
Maybe this will help you and AFAIK you can run PE exe’s on the PE partition.
Just tell them it’s a 64 bit app. And if they catch you, just tell them you meant it runs on 64bit machines.
1 Like
There’s another language?
Sql servers load data into memory to provide better performance and exploit the 64bit memory addresses, but they take ages to load into memory and unload from memory.
PE’s (exe’s) on 32bit windows can only use 2GB of ram, 3GB if its compiled and linked with a 3GB switch.
64bit PE’s (exe’s) on 64bit windows still cant use the full 64bit range of memory addresses, windows just wont allow it!
So what exactly does a 64bit program bring to the desktop, especially a Clarion desktop exe?
Nothing, because the database probably isnt even big enough to exceed the 2GB 32bit memory limit!
1 Like
My Clarion work these days are limited, perhaps two-three days a month. The reason is mainly because of the demand for web portals. So we expose a little, and then a little bit more and so on. I would have loved to have a working IDE like Clarion (or Clarion) for my web projects, but I have been waiting for 25 years and I am not getting any younger, and it seems that very few Clarion developers are born. At some point I had to make a decision on how I can be able to transfer the code to new developers and I have done some reseach on alternatives.
I had much fun with Python and Django, and saw possibilites to generate a lot from the Clarion IDE, but it was way too easy to make mistakes and difficult to track them down.
I work about 50% Java JSP and Oracle, and have never gotten to like it. I have a fight with the IDE, compiler, maven, jar-hell or just an exception that desides to pop up. Love the debugger though (using MyEclipse).
The rest of the time I spend with C# and MSSQL, and this I really like. I have started to decline request for functionality in Clarion that anyways should be put in the web apps and thus I slowly resolve my Clarion dependency. Recently, with Blazor, I have had much fun replicating the Clarion window controls and my templates as razor components and I have used the Clarion template language to generate my Entity Framework models from dictionary, so I have minimal workload maintaining the two interfaces. Since I am a single developer, I can use the Visual Studio Community and for 10USD a month I have a Github Copilot integration that generally makes coding new functionality much easier.
I don’t think I have spent money on third party yet.
I also use C# to create DLL’s that I can create wrappers for in Clarion, for example with XML generation and web service integration where my existing accessoires came short.
But talk about bugs! Walking into a work where NULL is something you have to take into account, is a PITA compared to Clarions mostly elegant handling of those. And the subtle differences in Java and C# make it easy to create errors which would have been impossible to find without a working debugger.
FWIW: Clarion is a beatiful language and the template system will always be my first true love.
2 Likes
I’m assuming we’re talking about a SQL Server here. The server can be (and almost certainly is) a 64 bit process. Most SQL databases can use lots of Ram to improve performance.
But this is irrelevant since the client program can be 32 bit, and would still get the benefit of yhat Ram.
An exception to this rule is SQLite, since that doesnt have a server, just a DLL, so shares the processes RAM.
As far as databases go, 2gb is on the “small” side, even the 10gb offered by SQL server express is often too small.
Not a whole lot. Its rare for a desktop program to use that much ram. Of course for server programs (like web servers) it brings a lot because it allows for more similtaneous threads.
And marketing. As we’ve seen in this thread and elsewhere, being 32 bit can be exploited by marketing departments.
I would definitely appreciate the extra space for imaging apps. It doesn’t really take too much effort to exceed the limits of LARGE_ADDRESS when working with large images.
Image process can benefit from extra memory, photoshop uses multiple layers in a z-order to do its stuff.
But a db, when its stripped back to just csv txt, hasnt in my experience exceeded 2GB.
Add in the indexes though and that sql server can balloon to 10-30GB in size easily.