# Merging columns for speed improvement

**URL:** <https://forum.adalo.com/t/merging-columns-for-speed-improvement/55265>\
**Category:** Get Help\
**Created:** [April 8, 2025, 9:02pm UTC](https://forum.adalo.com/t/merging-columns-for-speed-improvement/55265 "2025-04-08T21:02:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nadavma2](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/nadavma2/32/38071_2.png) [@nadavma2](https://forum.adalo.com/u/nadavma2)\
**Post date:** [April 8, 2025, 9:02pm UTC](https://forum.adalo.com/t/merging-columns-for-speed-improvement/55265/1 "2025-04-08T21:02:12Z")

</div>

Hi, I have a question about app speed:

I have a search that goes through a list of thousands of products, using keyword matching across 4 different columns. Would combining all the keywords into a single column improve adalo speed?

Thanks a lot!

---

<div class="post-metadata">

**Author:** ![nadavma2](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/nadavma2/32/38071_2.png) [@nadavma2](https://forum.adalo.com/u/nadavma2)\
**Post date:** [April 8, 2025, 9:06pm UTC](https://forum.adalo.com/t/merging-columns-for-speed-improvement/55265/2 "2025-04-08T21:06:18Z")

</div>

@Victor

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [April 9, 2025, 8:42am UTC](https://forum.adalo.com/t/merging-columns-for-speed-improvement/55265/4 "2025-04-09T08:42:08Z")

</div>

@nadavma2 you can make an experiment by yourself and share the result.

This question is difficult to answer as the performance change depend heavily on multiple factors: how Adalo processes search in the list on the frontend, what does it send to the backend and how backend DB search is being performed. Such information isn’t accessible to Adalo users.

I would expect that a DB query with a filter on a single column should work faster, but that depends on multiple factors (what is the underlying SQL query type, is this column indexed, etc etc etc).  
Maybe @wjgilmore can shed some light on this.

Best,  
Victor.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [April 19, 2025, 8:42am UTC](https://forum.adalo.com/t/merging-columns-for-speed-improvement/55265/5 "2025-04-19T08:42:20Z")

</div>

Closed on April 19, 2025, 8:42am UTC

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
