Freqently Asked Questions

Which IDEs can I use together with Ext Speeder?

NetBeans, Eclipse and IntelliJ IDEA.

Can I write custom code and override or change the generated code?

Yes. You can alter the behavior of the generated Java code. Your modifications will be retained even though the code is re-generated.

Which database types are supported?

Oracle, MySQL, PostgreSQL, DB2 and MS SQL and MariaDB.

My application is .Net (or Ruby on Rails, Node.js, php, c# etc.), can I still use Ext Speeder?

Ext Speeder is running Java internally, but can interact with any application thru our REST interface.

Does Ext Speeder require any changes in the database?

No. Ext Speeder can be used on any existing database schema.

Can I deploy Ext Speeder applications on AWS or Google Cloud?

Yes. Ext Speeder can be deployed in the cloud.

Can I use Ext Speeder to speed up my Ext JS charts too?

Yes. Any Sencha component that can use an Ext.data.BufferedStore can benefit from Ext Speeder.

Can I run Ext Speeder in Tomcat or another JavaEE server?

Yes. You can run it in any Java EE server such as Tomcat, Glassfish or WebLogic.

How long time does it take to load all data into memory?

Depends on the amount of data. 100,000,000 elements (rows * columns) are often loaded in less than 5 minutes on a common server hardware.

How much data can I use with Ext Speeder?

At least 100,000,000 elements (rows * columns) in-memory and unlimited using SQL.

How much faster is Ext Speeder in-memory compared to SQL?

Depends. Some apps becomes 10 times faster than standard configured databases, some other even faster than that.

How much memory do Ext Speeder require?

Depends on the amount of data. 100,000,000 elements (rows * columns) usually fits in 10 Gbytes.

How can Ext Speeder be so fast?

Ext Speeder uses an in-memory representation with indexes on every column. Sorting and filtering can be done instantly.

What are the typical query latencies for a large data set?

Queries are often served in less than 10 ms. Humans can not detect such low latencies.

How many grid users can Ext Speeder handle simultaneously?

Ext speeder can handle hundreds of requests per second on a server grade computer with no impact on the database.

Can I use Ext Speeder without using in-memory acceleration?

Yes. Usage of the in-memory accelerator can be controlled using the graphical tool.

How can Ext Speeder be fast while scrolling millions of records?

Ext Speeder maintains an in-memory lookup dictionary, allowing it to quickly skip in large data sets.

Can I decide the REST path (URL) myself?

Yes. You can configure your REST API using custom URLs. Any path can be used.

Can I sort my columns in any order?

Yes

Which filters are supported?

Equals, not equals, less than, less or equal, greater than, greater or equals and contains.

How does Ext Speeder store my secret password for the database?

It does not. You have to provide it either by configuration, code or manually.

Does Ext Speeder support secure connections with https: ?

Yes.

Can I run Ext Speeder using other languages e.g. .NET?

Yes. Despite the fact that Ext Speeder is running Java internally, you can benefit from using Ext Speeder even though you are using .NET using Ext Speeder’s standard REST interfaces.

Do I have to write custom Java code to use Ext Speeder?

No The code that Ext Speeder is generating will run out-of-the-box. The only thing you need to do is to point your EXT JS components (like grids) to the Ext Speeder server and port number instead of your old REST end points.

I try to run Ext Speeder but get the error “Could not find artifact com.oracle:ojdbc7:jar:12.1.0.1.0 ?

You need to download the Oracle Connector jar version 12.1.0.1.0 from the Oracle Website and install it on your local machine.
Here is a guide on how to install the jar.