# Scalability and Availability

* Sessionless and stateless web application<br>
* No server-side stay-in-memory objects<br>
* File data saved using the file or database system<br>
* Database size is small and network bandwidth usage is optimized<br>
* Deploy WorkflowGen in a web farm environment with load balancing<br>
* Use multiple servers for web applications, files, and databases<br>
* Use a real-time replicated secondary database to reduce server response time (database scaling feature)

## Scalability features

### Sessionless and stateless web application

* Totally compliant with load balancing and web farm architectures<br>
* Improves web server memory usage

### Product tuning

WorkflowGen offers several options to optimize storage size and response time according to your constraints. For example:

* You can reduce the amount of data displayed on the User Portal home page<br>
* You can define process data to keep all the versions of the data value by actions or only the late one

### File data storage

You can configure WorkflowGen to store file data in the database or in the file system. Database storage simplifies the file data administration and backup (without interruption of service).

File system storage provides the following benefits:

* Optimizes the database size and database server CPU load<br>
* Reduces the network bandwidth usage between the web server and the database server<br>
* File data can be stored in a local or remote folder

### Web farm

WorkflowGen supports web farm configuration; you can set up two or more web servers to handle workflow requests. Web farm configuration improves the performance and offers high availability.

### Database scaling

WorkflowGen provides a unique way to dramatically improve the response time of your processes thanks to database farms. In addition to the primary WorkflowGen database, you can set up another read-only database that is replicated with the primary database in close to real time. WorkflowGen will forward the read-only SQL queries to the replica database, and because there are more “read” queries than “write” commands, product performance is dramatically improved.

Database scaling is supported only with SQL Server databases.

### Unlimited scalability

For heavy usage with thousands of transactions per hour, you can combine the previous features to build a highly scalable BPM architecture; for example:

* Two load-balanced web servers<br>
* One primary database server<br>
* Two read-only replica database servers


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.workflowgen.com/features/9.5/scalability-and-availability.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.