The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Greetings,
I'm wondering if there is any way to speed up tables with no-primary keys (you know tables inserting records non-stop and deleting) where int or bigint will be a problem....where you store massive number of records that may change during... eg. like Active_users table
Since yesterday hit over 25K active at same time, 194K overall visit, I think one of reasons for that to update that file while users changing pages.
I'm wondering if there is any way to speed up tables with no-primary keys (you know tables inserting records non-stop and deleting) where int or bigint will be a problem....where you store massive number of records that may change during... eg. like Active_users table
Since yesterday hit over 25K active at same time, 194K overall visit, I think one of reasons for that to update that file while users changing pages.
Posted
I guess the question is how those tables are accessed and what type of performance problems you're experiencing.
Posted
Well, you know Active_Users table of Snitz. Very same :)
My performance problem is while users of 24K around same periods access data as they change pages, active users change pages as well.. So around 24K queries on a no-PK'd table sadly in less than 20 minutes periods.
My performance problem is while users of 24K around same periods access data as they change pages, active users change pages as well.. So around 24K queries on a no-PK'd table sadly in less than 20 minutes periods.
Posted
In what pages does that slow you down? Every page? Active users page?
Posted
Every page that calls activepages function (you know the function that adds users to list if they are not, or changes their location if they were already in the table)
Not listing or anything.
Not listing or anything.
Posted
Well I will try to have a look at what it does.