# Neam

[Neam ](https://neam.co/)helped a media and entertainment community platform reduce WU consumption by 400%. One of the key optimizations they made was improving the page-load speed by optimizing database searches.

## Optimization opportunity

When Neam reviewed their client’s app metrics, they found a process that was overly complex, highly repetitive, and ultimately impacting a high volume of data: Whenever the app needed to load data on a page, it was searching through the large database across the server-side and client-side.

## Optimizations:

* **Restructure the relational database so the app had to search through a smaller dataset:** For example, they split a ”project” data table into two separate but linked tables: ”project” and “project detail.” This allowed us to search on the main (project) data type and offload media-heavy data into the related or linked data type (project detail) that wasn’t needed in the initial search results. 
* **Use option sets for drop-downs:** Rather than relying on database calls, they turned common drop-down categories (e.g., statuses, types of projects) into option sets. <

  Add server-side filtering: By adding server-side filtering, the app improved search efficiency by offloading some processing away from the front-end.


---

# 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://manual.bubble.io/help-guides/workload/optimizing-workload/agency-showcases/neam.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.