By using this website, you agree to our Terms of Use (click here)
In terms of how much data you can query with AugSQL, I'm not sure yet what the limit is, but I thought I'd share this query that ran successfully in an Acumatica SaaS environment. It took a couple of minutes to run, but it came back successfully with 9 columns and 771,351 records.
Interesting that it took minutes, was there a lot of joins or non-indexed where clauses? Granted, I find Acumatica the slowest platform I've ever used 🙂
I'm late to the party on this, but is AugSQL a module that lets you run arbitrary queries?
Ya, the slowness is due to IIS, not SQL. I wish it was faster too 😀
AugSQL is a project that I'm working on. More info here:
@timrodman Ok now that makes a lot of sense that it's IIS! When I hop in to SQL Server Studio and run queries they run at full speed so I just figured Acumatica was running tons of extra queries on every page load or something. I'm also just playing with a local install without caching optimizations, so I'd hope that speeds things up when we actually deploy a live instance.
I built this machine for RAW video editing and Acumatica testing. Ryzen 9 5950X 16-Core CPU, 32GB RAM, 1TB m.2 storage. Graphics is NVIDIA GeForce RTX 3060 Ti FTW, which isn't going to benefit Acumatica performance but that's what I'm using.
Runs multiple VM's without breaking a sweat, so I was disappointed that Acumatica seemed so sluggish. I also noticed in all the video courses the presenter's systems are slow too, so it's not just me!
@charles-craig Ya, IIS is a big bottleneck right now, but the current move to .Net Core is a major rewrite of the application and will speed things up substantially because the processing will now be done locally, with the data getting passed back-and-forth using JSON.