# Gsheet doubt **URL:** \ **Category:** Ask for Help\ **Created:** [October 29, 2021, 6:15am UTC](https://community.glideapps.com/t/gsheet-doubt/33716 "2021-10-29T06:15:09Z")\ **Posts on this page:** 1\ **Showing post:** 12
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [November 1, 2021, 2:58pm UTC](https://community.glideapps.com/t/gsheet-doubt/33716/12 "2021-11-01T14:58:57Z")
Hola de nuevo! Well, the _Query(ImportRange())_ combination won’t be the magic solution but help to simplify results and reduce the columns quantity due to Query() function is able to work directly with columns needed by you and filter data dynamically (like a SQL statement). Years ago I tested this scenario with a GS with 150k rows and had “good results” but it was another time and an experimental test, not an APP in production. Here you can read it: > [@Importrange](https://community.glideapps.com/t/importrange/1635/11): > > I don’t think so George! Try using this: =Query(ImportRange()) and you will see how fast the data is updated. In my spreadsheets, If I modify or add a new record (I have 150.000 records in my source spreadsheet), my other sheet gets new data in less than 1 min. That is my sintaxys to get it: =query(IMPORTRANGE(“1mEoXgU2StLrYa9TbvX00RdGFHsa1RFV\_WP2Tnc7dtnw”,“Sheet 3!A1:F9”),"Select \* ", -1) I set up a timer trigger to change the date/time in some cells and I can see how my query retrieves… Saludos --- _[View the full topic](https://community.glideapps.com/t/gsheet-doubt/33716)._