Jonathan
CCConvex Community
•Created by Jonathan on 4/25/2025 in #support-community
Handling Updating Large amounts of Rows
but that may be expensive also
11 replies
CCConvex Community
•Created by Jonathan on 4/25/2025 in #support-community
Handling Updating Large amounts of Rows
well this case actually I was thinking of tagging rows in a table for more of search type things. Where I would be filtering limits higher than the normal limits, thinking my query for the search could just filter based on a tag, if the search requirements change, update all rows that the tags have
11 replies
CCConvex Community
•Created by Jonathan on 4/25/2025 in #support-community
Handling Updating Large amounts of Rows
yes , but realized I was asking this for another reason, I am trying to find how deep I dive this weekend, family is out of town for the weekend lol
11 replies
CCConvex Community
•Created by Jonathan on 4/25/2025 in #support-community
Handling Updating Large amounts of Rows
I tried to use Airbyte but it isn't going to really work because of some issues on my SQL Server with Change detection and just thinking I should clean some schema stuff up as I go
11 replies
CCConvex Community
•Created by Jonathan on 4/25/2025 in #support-community
Handling Updating Large amounts of Rows
yeah it is basically a migration and keeping it a live migration as data changes in the legacy system
11 replies
CCConvex Community
•Created by Jonathan on 4/25/2025 in #support-community
Normilization Best Practices
Yeah I think I have a lot of cases where in my SQL db I have a table that only holds like many to many, that are usually only a couple to the main entity.
Like
Contact to ContactRoles to Roles , maybe it has a few extra fields on the ContactRoles like start and end date but that is it6 replies
CCConvex Community
•Created by Jonathan on 4/25/2025 in #support-community
Normilization Best Practices
Yeah that seems to be my approach also
6 replies
CCConvex Community
•Created by Jonathan on 4/25/2025 in #support-community
AG-Grid Datasource
Potentially could build a custom server hook/filtering helper in addition to the client side piece.
4 replies
CCConvex Community
•Created by Jonathan on 4/14/2025 in #support-community
Migrating to Convex from RDMS/SQL
yeah if you point me in the direction I will put it on my list to check out
51 replies
CCConvex Community
•Created by Jonathan on 4/14/2025 in #support-community
Migrating to Convex from RDMS/SQL
I would think most I can ge tdown to less than 5k
51 replies
CCConvex Community
•Created by Jonathan on 4/14/2025 in #support-community
Migrating to Convex from RDMS/SQL
I would imagine a lot of cases there is part of the query that reduces the return by like 90%
51 replies