Slow performance when opening new table

V5 Issue
1

After I added the reservation module, now when I open a new table to add orders to the table it hangs for about 15 seconds on my second terminal. The main terminal where the DB is installed on, it hangs for about 2 seconds. Please help, my bar terminal is really slow, during a busy it’s difficult to work.

Note: opening a table that already has orders in it, it’s normal and it opens right away.

2

What is the specs of your system?

3

Hi, it’s Intel Core i7-3770 CPU @ 3.40GHz, 8 GB men 64bit system running win 10 pro ver 22h2

thank you

4

I’ve uploaded a video showing the issue, let me know if that helps, thank you!

[pos.m4v.zip|attachment](upload://8SDisbFqFwOP5H4fzES3acx4u6r.zip) (7.8 MB)
5

Can you upload it to youtube and paste it here?

6

execute this script in your sql server management studio under your database , pls do a backup first of your database before you run this sql

BEGIN TRANSACTION;
BEGIN TRY
    DECLARE @ErrorMessage NVARCHAR(MAX);
    DECLARE @ErrorSeverity INT;
    DECLARE @ErrorState INT;

    DELETE FROM dbo.Tasks;

    COMMIT TRANSACTION;
END TRY
BEGIN CATCH
    IF @@TRANCOUNT > 0
    BEGIN
        ROLLBACK TRANSACTION;

        SET @ErrorMessage = ERROR_MESSAGE();
        SET @ErrorSeverity = ERROR_SEVERITY();
        SET @ErrorState = ERROR_STATE();
        RAISERROR(@ErrorMessage, @ErrorSeverity, @ErrorState);
    END;
END CATCH;

This script safely deletes all tasks from the Tasks table. If anything goes wrong during the deletion, it rolls back and reports the error.

after you are done running the script, test to see if its still slow when opening tables

1 Like
7

Worked like a charm, thank you, the whole system became more responsive in all stations, thank you.