Oracle SQL Developer Scalability
Personally, the product scales to my needs.
View full review »As our company keeps on growing, our data also keeps on growing.
Currently, we are a $12-billion company and this tool supports us.
Our projection in the future, is to grow from $12 billion to $20 billion in the next three years and I am not sure whether it might help then or not, as our data will also grow consequently.
MK
Martin Klier
Senior Database Consultant at Performing Databases
Scalability has room for improvement. Often if you have to do a heavy load of queries or are getting large result sets you have to be careful not to overload the Java virtual machine that's running.
View full review »From a scalability point of view, because it's just an install on each machine individually, scalability is not really an issue. Because we're in a network environment, we're able to actually have SQL Developer share file system space. We can point SQL Developer to the shared space. Those types of things weren't really an issue. It's not like we add people to using the one instance.
SQL Developer is able to handle hundreds of thousands of rows and columns. I haven't seen any instance where SQL Developer itself is the issue. Most times, what we've seen is that, either I've got a memory constraint issue on the machines, so I can only load in so much stuff, and SQL Developer has a configuration point that limits the amount of rows you get back from this database to 500, or whatever that is.
You can address system limitations. We've run into experiences where people say, "Oh, this is running slow." It tends to be slow because a bad query that has been written, and SQL Developer has tools to go in and look at the SQL and start doing troubleshooting. Or, you're trying to run something big in the middle of a financial close, and actually the resources you're trying to reach are being consumed by other things.
As far as running SQL Developer itself - outside of the Java compatibility issues where you might see SQL Dev not find Java or hang because it doesn't have the right version - the actual ability for the tool itself to grab the data, I have not run into a scenario where it's SQL Developer, so much as I have run into it's actually the machine that I'm using that may be limited in resources.
View full review »Oracle SQL Developer is scalable. It can perform the same when more people use it.
Most of the people in my organization are using Oracle SQL Developer. We have approximately 100 people in the organization.
View full review »It seems to scale fine. If you're trying to return exceedingly large data sets into the tool for some reason to download, that could be a challenge, depending on the memory on your machine and the disk space you have to output it to. Oracle will perform the query just, depending on how well your database is tuned, but oyu do need space for the output.
On the Data Modeler side, people do run into issues with very large models with hundreds and thousands of objects, but there is actually a memory parameter and a config file which you can tweak to increase the amount of memory that the tool uses. That, of course, is then limited only by how much memory you have on the workstation you're using.
View full review »It is just client. It does not really matter. It is scalable, especially the newer version is non-GUI version. You do not have to install it, just dump it on the OS, then use it.
View full review »We did not encounter any issues with scalability.
View full review »No scalability issues.
View full review »To be frank, I haven’t had the chance to evaluate this software with respect to its scalability.
View full review »It is scalable. Although, we don't use it to get large data, still it is scalable.
View full review »It can be used by many because it's mainly a client-server.
View full review »I only work on a Lenovo Windows machine. I don't work on Apples. I don't know if it's scalable there or not.
View full review »The scalability is very good. It can scale out, up.
View full review »It's scalable.
View full review »I have never stressed the product to find out.
No scalability issues as of yet.
View full review »There have been no issues with scalability.
View full review »I did not encounter any issues with scalability.
View full review »Scalability is very good.
View full review »It's scalable. Everybody can install it on his or her machine.
View full review »No problem with scalability.
View full review »