iBasskung Framework — 25–30 Million Record Stress Test

Performance, Edge Cases, and What We Chose Not to Fix

Test period: August 18–19, 2026
Test stack: WinForms + SQL Server + iBasskung Framework
Dataset: 25,000,000–30,000,000 Orders
Objective: Evaluate the limits of Data Access, Paging, Search, UX behavior, and edge cases at enterprise-scale data volumes

This test was not designed to prove that iBasskung Framework is “the fastest” or that it has no limitations.

The goal was much simpler: push the dataset to 25–30 million records, observe what still performs well, identify where latency starts to increase, and document the issues that may need attention later.

The guiding principle throughout the test was:

Measure what actually happened, report both strengths and weaknesses, and avoid claiming a root cause that has not been proven by evidence.

1. 30 Million Records Does Not Mean Loading 30 Million Rows into the DataGridView

The architecture being tested does not attempt to load the entire dataset into the UI.

The basic flow is:

Database
   ↓
COUNT / Filter
   ↓
Calculate total pages
   ↓
Fetch only the current page
   ↓
Render the result in the UI

So when we say the system was tested with 30 million records, that refers to the size of the dataset the system had to manage—not 30 million rows being loaded into the DataGridView at once.

That distinction matters in enterprise desktop applications.

2. Initial Load: 25M and 30M Remained in the Sub-Second Range

Measured results from the initial paging load:

Dataset	Pages @ 100 rows	COUNT	First Page Fetch	End-to-End
25,000,000	250,000	~235–280ms	~1–8ms	~238–292ms
30,000,000	300,000	~281–333ms	~1–8ms	~286–345ms

The important point is not simply that “30 million is fast.”

Most of the initial latency comes from the COUNT operation rather than fetching the rows for the first page.

The actual page retrieval remains in the single-digit millisecond range.

3. Deep Pagination: We Actually Tested the Last Page

One of the main goals of the test was to avoid measuring only Page 1.

25M records

With a page size of 100:

25,000,000 ÷ 100 = 250,000 pages

We tested navigation such as:

Page 1
Page 2
Page 3
...
Page 250,000
Page 249,999
...
Page 249,995
Page 1

Observed results included:

Page 250,000 → ~2ms fetch
Page 249,999 → ~1ms
Page 249,998 → ~1ms
Page 249,997 → ~2ms
Page 249,996 → ~2ms
Page 249,995 → ~1ms

30M records

With the same page size:

30,000,000 ÷ 100 = 300,000 pages

We tested up to:

Page 300,000 / 300,000

Observed results included:

Page 300,000 → 5ms
Page 299,999 → 1ms
Page 299,998 → 1ms
Page 299,997 → 1ms
Page 299,996 → 1ms
Page 299,995 → 1ms

Based on the measured logs, deep-page retrieval did not show the kind of latency growth that would normally be associated with increasing page depth.

We are deliberately not calling this “proven O(1) pagination,” because a benchmark alone does not mathematically establish Big-O complexity.

A more accurate statement is:

Page retrieval remained in the millisecond range even when navigating through hundreds of thousands of pages.

4. Page Size 50 and 100 Also Remained Stable

At 30 million records:

Page Size 100

300,000 pages

We navigated to Page 300,000 and back.

Observed fetch times remained approximately:

1–5ms

Page Size 50

600,000 pages

We navigated to:

Page 600,000 / 600,000

and back through the final pages.

Observed fetch times remained approximately:

1–4ms

This suggests that the paging interaction itself remained stable even as the total number of pages increased significantly.

5. Search: Most of the Time Is Not Spent Fetching the Page

Search results that matched several million rows showed a consistent pattern.

Examples from the 25M test:

Keyword	Matching Rows	COUNT	First Page Fetch
`tanin s`	4,999,995	383ms	2ms
`tanin`	4,999,995	382–388ms	2ms
`tani`	4,999,995	383ms	2ms
`tan`	4,999,995	396ms	2ms
`ta`	4,999,995	385ms	2ms
`t`	4,999,995	386ms	3ms
`ibasskung ai`	4,999,998	392ms	3ms
`arjan best`	5,000,010	384ms	1ms
`jane doe`	4,999,999	381ms	2ms

At 30 million records:

Searches matching around 6M rows were typically around 470–490ms
completed, matching 27M rows, took about 620ms
voided, matching 3M rows, took about 460ms

The pattern is clear:

COUNT is significantly more expensive than fetching the current page.

Searching several million records does not mean several million rows are loaded into the UI.

Only the current page is fetched.

6. Zero-Result Short-Circuit Is Working as Intended

When a search returns no matches, the database still has to determine that there are no matching rows.

But once the system knows:

TotalRows = 0

it does not perform a page fetch.

For example, in the 25M test:

COUNT = 406ms
FirstPageFetch = 0ms
End-to-End = 0ms

Another example:

COUNT = 395ms
FirstPageFetch = 0ms
End-to-End = 0ms

The same behavior was observed in the 30M test.

An important clarification:

“0ms” in these cases does not mean the COUNT operation took 0ms. It means that after COUNT returned zero results, the application performed no additional page fetch.

This prevents unnecessary database work.

7. Debounce + CancellationToken Under Rapid Typing

Search was not tested only with carefully entered keywords.

The test also included rapid typing sequences such as:

arjan best
arjan be
arja
arj
ar
a

and several periods where many keystrokes were generated within a few seconds.

The architecture uses:

700ms debounce + CancellationToken

The observed pattern was:

Keystroke
   ↓
Reset debounce timer
   ↓
User continues typing
   ↓
Reset timer again
   ↓
Cancel previous request
   ↓
Execute latest query

The logs show repeated cancellation of previous requests before the latest query was executed.

No stale result was observed being rendered after a newer request in this test.

That should be interpreted as:

No stale-result or related UI issue was observed during this test set.

It is not a claim that every possible concurrency scenario has been formally proven race-free.

8. Security and Adversarial Input Testing

The stress test also included unusual inputs designed to exercise the search and data-access layers.

Examples included:

' OR '1'='1
'; DROP TABLE Orders; --
admin'--
' OR 1=1 --
<script>alert(1)</script>
..\..\..\Windows\System32
C:\Program Files\
| calc.exe

Unicode edge cases were also tested:

\u200B
สิ่ี้้็๊๋
น้ำำำำำำำำำำ
Thai + English mixed input
Korean input

Across these test cases:

No SQL query failure was observed
No exception was observed
Inputs that did not match returned TotalRows = 0
The expected parameterized-query behavior was maintained

This should be treated as a behavioral test of the Search/Data Access layer, not as a claim that the Framework has passed a complete security audit.

9. Known Performance Edge Case: Special LIKE Patterns

This is one of the most useful findings from the stress test.

At 30 million records, certain patterns produced significantly higher COUNT latency:

%_%_%_%_%
[%]
[a-z]

Measured results:

Pattern	COUNT
`%_%_%_%_%`	~1,959ms
`[%]`	~1,942ms
`[a-z]`	~1,952ms

Normal searches in the same dataset were generally in the ~280–700ms range.

That means some special patterns were approximately 4× slower.

The performance anomaly is reproducible.

However, we are deliberately not claiming that the exact SQL Server execution-plan cause has been proven.

There is a hypothesis that bracket-based LIKE escaping may prevent SQL Server from applying the same optimization strategy used for normal prefix patterns. Confirming that would require inspection of the actual execution plan and additional SQL-level measurements.

For now, the issue is recorded as:

Known Performance Edge Case — Reproducible, Root Cause Not Yet Fully Proven

10. Why We Chose Not to Fix It Yet

This is an intentional engineering decision, not an overlooked issue.

One possible optimization is to move from bracket-based escaping to:

LIKE @Pattern ESCAPE '\'

However, there is not enough evidence to justify changing the Data Access Layer solely for this edge case yet.

The reasons are straightforward:

Keywords of this form are not typical user search behavior.
Debounce + cancellation prevents old requests from accumulating.
The observed issue affects COUNT latency, not paging correctness or UI rendering.
The exact SQL execution-plan root cause has not yet been confirmed.
Changing escaping semantics requires every affected LIKE query to be updated consistently. A missed ESCAPE clause could create a silent search correctness problem.

For us:

Correctness comes before micro-optimization.

If real production usage shows that these patterns become common, or if the dataset grows enough for this latency to become material, the optimization becomes much easier to justify.

11. What the 25M and 30M Tests Actually Tell Us

After testing both 25M and 30M records, the overall picture is fairly clear.

Data Scale

25M → 30M records

Paging remained operational without a visible collapse in page-fetch latency.

Paging

250,000 pages
600,000 pages
300,000 pages

Deep navigation remained in the millisecond range in the measured scenarios.

Search

Searches matching millions of rows still produced ~1–4ms first-page fetches.

The heavier part of the operation is the COUNT.

UX

Rapid typing worked together with:

700ms debounce + CancellationToken

with no stale-result issue observed during the test.

Edge Cases

The stress test also exposed a reproducible performance anomaly that does not appear during ordinary searches.

That is exactly what a stress test is supposed to do.

12. What Still Needs Work

This test does not mean the architecture is finished.

Several areas remain worth investigating.

COUNT Scaling

As the dataset grows from 30M toward 100M+ records, search COUNT performance will become increasingly important, particularly for text searches using LIKE.

Index strategy and search architecture may eventually need to evolve.

Special LIKE Patterns

The ~1.9-second COUNT anomaly is a known limitation.

The next step is to verify the actual SQL Server execution plan before deciding whether an escaping or indexing optimization is justified.

Concurrent Workload

These tests primarily focused on single-user interaction.

A valuable next stage would be concurrent workload testing with multiple users and queries to measure:

CPU utilization
I/O
connection usage
worker time
query concurrency
database contention

That would move the testing from data-scale stress testing toward enterprise workload testing.

13. The Real Lesson From the Stress Test

A stress test should not end with:

“It passed. The system is fast.”

That does not tell us where the architecture is strong, where it is weak, or where it may eventually fail.

The more useful outcome is knowing:

30M Records
     ↓
Paging remains fast
     ↓
Deep navigation remains fast
     ↓
Page fetch remains fast
     ↓
COUNT is the heavier operation
     ↓
Some patterns expose a limitation
     ↓
The limitation is documented
     ↓
Optimization is deferred until evidence justifies it

That is the real value of stress testing.

It is not about proving that software has no limitations.

It is about pushing the software far enough to expose those limitations—and then deciding what is worth fixing.

Conclusion

Based on the measurements collected during the August 18–19, 2026 tests:

Maximum dataset: 30,000,000 Orders
Full dataset at Page Size 100: 300,000 pages
Page Size 50: 600,000 pages
Typical page fetch: ~1–5ms
30M initial End-to-End: ~286–345ms
Search COUNT for several-million-row matches: typically ~380–620ms
Zero-result searches: no additional page fetch after COUNT returns zero
Rapid typing: tested with 700ms debounce + CancellationToken
Adversarial search inputs: tested without observed exceptions or abnormal query behavior
Known limitation: certain special LIKE patterns produced COUNT times of approximately ~1.9 seconds

So the most accurate conclusion is not:

“WinForms can handle 30 million records with no problems.”

It is:

“In our tests, iBasskung Framework maintained millisecond-level page retrieval and sub-second end-to-end interaction across many scenarios at 25–30 million records, while the stress tests also exposed performance edge cases that still require further investigation.”

For enterprise software, the valuable outcome may not be proving that there are no limitations.

It is knowing:

where those limitations are, how to measure them, and when it is worth addressing them.

Raw Diagnostic Trace (Unedited Visual Studio Output)

25 Million Records Stress Test Results — 18-08-2026

// Initial form load

20:11:20:501 [CONFIG] Range Set: 2022-01-01 to 2026-12-31

20:11:20:748 [ClassicPaging STATS] Page=1/250000 | Fetch=7ms | End-to-End=8ms

20:11:20:748 [SalesHistory Paging INIT] Keyword='' | TotalRows=25,000,000 | COUNT=280ms | FirstPageFetch=7ms | End-to-End=292ms

20:11:26:904 [Selected Tab]: tabPage16 : 3 // Navigated to Sales History tab

20:11:35:486 [ClassicPaging STATS] Page=1/50000 | Fetch=4ms | End-to-End=6ms

20:11:40:685 [ClassicPaging STATS] Page=1/50000 | Fetch=2ms | End-to-End=4ms

20:11:40:685 [SalesHistory Paging INIT] Keyword='tanin s' | TotalRows=4,999,995 | COUNT=383ms | FirstPageFetch=2ms | End-to-End=389ms

20:11:43:807 [ClassicPaging STATS] Page=1/50000 | Fetch=2ms | End-to-End=4ms

20:11:43:807 [SalesHistory Paging INIT] Keyword='tanin' | TotalRows=4,999,995 | COUNT=382ms | FirstPageFetch=2ms | End-to-End=387ms

20:11:46:130 [ClassicPaging STATS] Page=1/50000 | Fetch=2ms | End-to-End=4ms

20:11:46:130 [SalesHistory Paging INIT] Keyword='tanin' | TotalRows=4,999,995 | COUNT=388ms | FirstPageFetch=2ms | End-to-End=393ms

20:11:48:206 [ClassicPaging STATS] Page=1/50000 | Fetch=2ms | End-to-End=4ms

20:11:48:206 [SalesHistory Paging INIT] Keyword='tani' | TotalRows=4,999,995 | COUNT=383ms | FirstPageFetch=2ms | End-to-End=389ms

20:11:50:555 [ClassicPaging STATS] Page=1/50000 | Fetch=2ms | End-to-End=5ms

20:11:50:555 [SalesHistory Paging INIT] Keyword='tan' | TotalRows=4,999,995 | COUNT=396ms | FirstPageFetch=2ms | End-to-End=402ms

20:11:52:650 [ClassicPaging STATS] Page=1/50000 | Fetch=2ms | End-to-End=5ms

20:11:52:650 [SalesHistory Paging INIT] Keyword='ta' | TotalRows=4,999,995 | COUNT=385ms | FirstPageFetch=2ms | End-to-End=392ms

20:11:54:740 [ClassicPaging STATS] Page=1/50000 | Fetch=3ms | End-to-End=5ms

20:11:54:740 [SalesHistory Paging INIT] Keyword='t' | TotalRows=4,999,995 | COUNT=386ms | FirstPageFetch=3ms | End-to-End=392ms

20:11:56:539 [ClassicPaging STATS] Page=1/250000 | Fetch=1ms | End-to-End=3ms

20:11:56:539 [SalesHistory Paging INIT] Keyword='' | TotalRows=25,000,000 | COUNT=236ms | FirstPageFetch=1ms | End-to-End=240ms

20:12:02:237 [ClassicPaging STATS] Page=1/50000 | Fetch=2ms | End-to-End=5ms

20:12:02:237 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=4,999,995 | COUNT=383ms | FirstPageFetch=2ms | End-to-End=389ms

20:12:05:822 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

20:12:05:822 [SalesHistory Paging INIT] Keyword='tanin s. not found' | TotalRows=0 | COUNT=406ms | FirstPageFetch=0ms | End-to-End=0ms

20:12:10:720 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

20:12:10:720 [SalesHistory Paging INIT] Keyword='tanin s. not found ไม่พบ' | TotalRows=0 | COUNT=395ms | FirstPageFetch=0ms | End-to-End=0ms

20:12:15:129 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

20:12:15:129 [SalesHistory Paging INIT] Keyword='tanin s. not found ไม่พบหา' | TotalRows=0 | COUNT=395ms | FirstPageFetch=0ms | End-to-End=0ms

20:12:20:816 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

20:12:20:816 [SalesHistory Paging INIT] Keyword='tanin s. not found ไม่พบ' | TotalRows=0 | COUNT=399ms | FirstPageFetch=0ms | End-to-End=0ms

20:12:23:414 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

20:12:23:414 [SalesHistory Paging INIT] Keyword='tanin s. not found ไ' | TotalRows=0 | COUNT=397ms | FirstPageFetch=0ms | End-to-End=0ms

20:12:27:009 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

20:12:27:009 [SalesHistory Paging INIT] Keyword='tanin s. not fo' | TotalRows=0 | COUNT=401ms | FirstPageFetch=0ms | End-to-End=0ms

20:12:30:416 [ClassicPaging STATS] Page=1/50000 | Fetch=3ms | End-to-End=4ms

20:12:30:416 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=4,999,995 | COUNT=381ms | FirstPageFetch=3ms | End-to-End=386ms

20:12:38:654 [ClassicPaging STATS] Page=1/50000 | Fetch=3ms | End-to-End=5ms

20:12:38:654 [SalesHistory Paging INIT] Keyword='ibasskung ai' | TotalRows=4,999,998 | COUNT=392ms | FirstPageFetch=3ms | End-to-End=398ms

20:12:45:649 [ClassicPaging STATS] Page=1/50001 | Fetch=1ms | End-to-End=3ms

20:12:45:649 [SalesHistory Paging INIT] Keyword='arjan best' | TotalRows=5,000,010 | COUNT=384ms | FirstPageFetch=1ms | End-to-End=388ms

20:12:52:900 [ClassicPaging STATS] Page=1/50000 | Fetch=2ms | End-to-End=4ms

20:12:52:900 [SalesHistory Paging INIT] Keyword='jane doe' | TotalRows=4,999,999 | COUNT=381ms | FirstPageFetch=2ms | End-to-End=386ms

20:12:59:408 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

20:12:59:408 [SalesHistory Paging INIT] Keyword='sus\' | TotalRows=0 | COUNT=392ms | FirstPageFetch=0ms | End-to-End=0ms

20:13:00:717 [ClassicPaging STATS] Page=1/250000 | Fetch=1ms | End-to-End=2ms

20:13:00:717 [SalesHistory Paging INIT] Keyword='' | TotalRows=25,000,000 | COUNT=235ms | FirstPageFetch=1ms | End-to-End=238ms

20:13:03:286 [ClassicPaging STATS] Page=1/50000 | Fetch=3ms | End-to-End=5ms

20:13:03:286 [SalesHistory Paging INIT] Keyword='system bot' | TotalRows=4,999,998 | COUNT=385ms | FirstPageFetch=3ms | End-to-End=392ms

20:13:16:959 [ClassicPaging STATS] Page=2/50000 | Fetch=5ms | End-to-End=6ms

20:13:16:959 [PagingBar] Navigated to page 2 | Fetch=5ms | Total=6ms

20:13:18:269 [ClassicPaging STATS] Page=3/50000 | Fetch=3ms | End-to-End=5ms

20:13:18:269 [PagingBar] Navigated to page 3 | Fetch=3ms | Total=5ms

20:13:19:029 [ClassicPaging STATS] Page=4/50000 | Fetch=4ms | End-to-End=5ms

20:13:19:029 [PagingBar] Navigated to page 4 | Fetch=4ms | Total=5ms

20:13:19:818 [ClassicPaging STATS] Page=5/50000 | Fetch=3ms | End-to-End=5ms

20:13:19:818 [PagingBar] Navigated to page 5 | Fetch=3ms | Total=5ms

20:13:20:570 [ClassicPaging STATS] Page=6/50000 | Fetch=4ms | End-to-End=5ms

20:13:20:570 [PagingBar] Navigated to page 6 | Fetch=4ms | Total=5ms

20:13:22:135 [ClassicPaging STATS] Page=50000/50000 | Fetch=4ms | End-to-End=5ms

20:13:22:135 [PagingBar] Navigated to page 50000 | Fetch=4ms | Total=5ms

20:13:24:227 [ClassicPaging STATS] Page=49999/50000 | Fetch=1ms | End-to-End=2ms

20:13:24:227 [PagingBar] Navigated to page 49999 | Fetch=1ms | Total=2ms

20:13:24:994 [ClassicPaging STATS] Page=49998/50000 | Fetch=1ms | End-to-End=2ms

20:13:24:994 [PagingBar] Navigated to page 49998 | Fetch=1ms | Total=2ms

20:13:26:042 [ClassicPaging STATS] Page=49997/50000 | Fetch=1ms | End-to-End=4ms

20:13:26:042 [PagingBar] Navigated to page 49997 | Fetch=1ms | Total=4ms

20:13:26:826 [ClassicPaging STATS] Page=49996/50000 | Fetch=1ms | End-to-End=2ms

20:13:26:826 [PagingBar] Navigated to page 49996 | Fetch=1ms | Total=2ms

20:13:27:594 [ClassicPaging STATS] Page=49995/50000 | Fetch=1ms | End-to-End=3ms

20:13:27:594 [PagingBar] Navigated to page 49995 | Fetch=1ms | Total=3ms

20:13:29:160 [ClassicPaging STATS] Page=1/50000 | Fetch=4ms | End-to-End=5ms

20:13:29:160 [PagingBar] Navigated to page 1 | Fetch=4ms | Total=5ms

20:13:39:251 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

20:13:39:251 [SalesHistory Paging INIT] Keyword='system bot หาไม่พบครับ' | TotalRows=0 | COUNT=407ms | FirstPageFetch=0ms | End-to-End=0ms

20:13:43:160 [ClassicPaging STATS] Page=1/250000 | Fetch=1ms | End-to-End=2ms

20:13:43:160 [SalesHistory Paging INIT] Keyword='' | TotalRows=25,000,000 | COUNT=235ms | FirstPageFetch=1ms | End-to-End=239ms

20:13:47:809 [ClassicPaging STATS] Page=2/250000 | Fetch=1ms | End-to-End=2ms

20:13:48:072 [PagingBar] Navigated to page 2 | Fetch=1ms | Total=2ms

20:13:48:823 [ClassicPaging STATS] Page=3/250000 | Fetch=1ms | End-to-End=2ms

20:13:49:843 [ClassicPaging STATS] Page=4/250000 | Fetch=1ms | End-to-End=3ms

20:13:49:843 [PagingBar] Navigated to page 4 | Fetch=1ms | Total=3ms

20:13:50:595 [ClassicPaging STATS] Page=5/250000 | Fetch=1ms | End-to-End=2ms

20:13:50:595 [PagingBar] Navigated to page 5 | Fetch=1ms | Total=2ms

20:13:51:365 [ClassicPaging STATS] Page=6/250000 | Fetch=1ms | End-to-End=3ms

20:13:51:365 [PagingBar] Navigated to page 6 | Fetch=1ms | Total=3ms

20:13:53:702 [ClassicPaging STATS] Page=250000/250000 | Fetch=2ms | End-to-End=3ms

20:13:53:702 [PagingBar] Navigated to page 250000 | Fetch=2ms | Total=3ms

20:13:55:745 [ClassicPaging STATS] Page=249999/250000 | Fetch=1ms | End-to-End=2ms

20:13:55:745 [PagingBar] Navigated to page 249999 | Fetch=1ms | Total=2ms

20:13:56:774 [ClassicPaging STATS] Page=249998/250000 | Fetch=1ms | End-to-End=2ms

20:13:56:774 [PagingBar] Navigated to page 249998 | Fetch=1ms | Total=2ms

20:13:57:559 [ClassicPaging STATS] Page=249997/250000 | Fetch=2ms | End-to-End=3ms

20:13:57:559 [PagingBar] Navigated to page 249997 | Fetch=2ms | Total=3ms

20:13:58:605 [ClassicPaging STATS] Page=249996/250000 | Fetch=2ms | End-to-End=3ms

20:13:58:605 [PagingBar] Navigated to page 249996 | Fetch=2ms | Total=3ms

20:13:59:357 [ClassicPaging STATS] Page=249995/250000 | Fetch=1ms | End-to-End=4ms

20:13:59:357 [PagingBar] Navigated to page 249995 | Fetch=1ms | Total=4ms

20:14:00:906 [ClassicPaging STATS] Page=1/250000 | Fetch=1ms | End-to-End=2ms

20:14:00:906 [PagingBar] Navigated to page 1 | Fetch=1ms | Total=2ms

30 Million Records Stress Test Results — 19-08-2026

// Initial form load

13:08:26:991 [CONFIG] Range Set: 2022-01-01 to 2026-12-31

13:08:27:246 [ClassicPaging STATS] Page=1/300000 | Fetch=8ms | End-to-End=9ms

13:08:27:246 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=333ms | FirstPageFetch=8ms | End-to-End=345ms

13:08:41:491 [Selected Tab]: tabPage16 : 3 // Navigated to Sales History tab

13:08:44:628 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:08:45:383 [Search Engine] Debounce settled. Executing paged query for keyword: '' OR '1'='1'...

13:08:46:157 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:08:46:157 [SalesHistory Paging INIT] Keyword='' OR '1'='1' | TotalRows=0 | COUNT=729ms | FirstPageFetch=0ms | End-to-End=0ms

13:09:08:579 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:09:09:086 [Async Control] Cancelling previous pending search request via CancellationToken...

13:09:09:086 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:09:09:350 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:09:09:350 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=285ms | FirstPageFetch=1ms | End-to-End=290ms

13:09:11:410 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:09:11:932 [Async Control] Cancelling previous pending search request via CancellationToken...

13:09:11:932 [Search Engine] Debounce settled. Executing paged query for keyword: ''; DROP TABLE Orders; --'...

13:09:12:707 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:09:12:707 [SalesHistory Paging INIT] Keyword=''; DROP TABLE Orders; --' | TotalRows=0 | COUNT=768ms | FirstPageFetch=0ms | End-to-End=0ms

13:09:31:895 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:09:32:695 [Async Control] Cancelling previous pending search request via CancellationToken...

13:09:32:695 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:09:32:943 [ClassicPaging STATS] Page=1/300000 | Fetch=2ms | End-to-End=3ms

13:09:32:943 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=290ms | FirstPageFetch=2ms | End-to-End=297ms

13:09:33:741 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:09:34:262 [Async Control] Cancelling previous pending search request via CancellationToken...

13:09:34:262 [Search Engine] Debounce settled. Executing paged query for keyword: 'admin'--'...

13:09:34:760 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:09:34:760 [SalesHistory Paging INIT] Keyword='admin'--' | TotalRows=0 | COUNT=456ms | FirstPageFetch=0ms | End-to-End=0ms

13:09:46:167 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:09:46:954 [Async Control] Cancelling previous pending search request via CancellationToken...

13:09:46:954 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:09:47:215 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:09:47:215 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=282ms | FirstPageFetch=1ms | End-to-End=288ms

13:09:47:983 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:09:48:740 [Async Control] Cancelling previous pending search request via CancellationToken...

13:09:48:740 [Search Engine] Debounce settled. Executing paged query for keyword: '%_%_%_%_%'...

13:09:50:537 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:09:50:537 [SalesHistory Paging INIT] Keyword='%_%_%_%_%' | TotalRows=0 | COUNT=1959ms | FirstPageFetch=0ms | End-to-End=0ms

13:10:02:502 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:10:03:009 [Async Control] Cancelling previous pending search request via CancellationToken...

13:10:03:009 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:10:03:505 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:10:03:505 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=288ms | FirstPageFetch=1ms | End-to-End=294ms

13:10:04:286 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:10:04:810 [Async Control] Cancelling previous pending search request via CancellationToken...

13:10:04:810 [Search Engine] Debounce settled. Executing paged query for keyword: '[%]'...

13:10:06:902 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:10:06:902 [SalesHistory Paging INIT] Keyword='[%]' | TotalRows=0 | COUNT=1942ms | FirstPageFetch=0ms | End-to-End=0ms

13:10:19:902 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:10:20:702 [Async Control] Cancelling previous pending search request via CancellationToken...

13:10:20:702 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:10:20:963 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:10:20:963 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=286ms | FirstPageFetch=1ms | End-to-End=291ms

13:10:21:485 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:10:22:254 [Async Control] Cancelling previous pending search request via CancellationToken...

13:10:22:254 [Search Engine] Debounce settled. Executing paged query for keyword: '[a-z]'...

13:10:24:052 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:10:24:052 [SalesHistory Paging INIT] Keyword='[a-z]' | TotalRows=0 | COUNT=1952ms | FirstPageFetch=0ms | End-to-End=0ms

13:10:34:856 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:10:35:361 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:10:36:146 [Async Control] Cancelling previous pending search request via CancellationToken...

13:10:36:146 [Search Engine] Debounce settled. Executing paged query for keyword: 'sus\'...

13:10:36:409 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:10:36:409 [SalesHistory Paging INIT] Keyword='sus\' | TotalRows=0 | COUNT=456ms | FirstPageFetch=0ms | End-to-End=0ms

13:10:44:161 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:10:44:946 [Async Control] Cancelling previous pending search request via CancellationToken...

13:10:44:946 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:10:45:207 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:10:45:207 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=283ms | FirstPageFetch=1ms | End-to-End=288ms

13:10:45:974 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:10:46:744 [Async Control] Cancelling previous pending search request via CancellationToken...

13:10:46:744 [Search Engine] Debounce settled. Executing paged query for keyword: 'sus\'...

13:10:47:270 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:10:47:270 [SalesHistory Paging INIT] Keyword='sus\' | TotalRows=0 | COUNT=455ms | FirstPageFetch=0ms | End-to-End=0ms

13:10:58:878 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:10:59:386 [Async Control] Cancelling previous pending search request via CancellationToken...

13:10:59:386 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:10:59:895 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:10:59:895 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=282ms | FirstPageFetch=1ms | End-to-End=287ms

13:11:00:418 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:11:00:939 [Async Control] Cancelling previous pending search request via CancellationToken...

13:11:00:939 [Search Engine] Debounce settled. Executing paged query for keyword: 'test\''...

13:11:01:435 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:11:01:435 [SalesHistory Paging INIT] Keyword='test\'' | TotalRows=0 | COUNT=451ms | FirstPageFetch=0ms | End-to-End=0ms

13:11:12:061 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:11:12:799 [Async Control] Cancelling previous pending search request via CancellationToken...

13:11:12:799 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:11:13:062 [ClassicPaging STATS] Page=1/300000 | Fetch=2ms | End-to-End=3ms

13:11:13:062 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=282ms | FirstPageFetch=2ms | End-to-End=288ms

13:11:13:553 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:11:14:323 [Async Control] Cancelling previous pending search request via CancellationToken...

13:11:14:323 [Search Engine] Debounce settled. Executing paged query for keyword: 'C:\Program Files\'...

13:11:14:833 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:11:14:833 [SalesHistory Paging INIT] Keyword='C:\Program Files\' | TotalRows=0 | COUNT=448ms | FirstPageFetch=0ms | End-to-End=0ms

13:11:23:401 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:11:23:938 [Async Control] Cancelling previous pending search request via CancellationToken...

13:11:23:938 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:11:24:186 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:11:24:186 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=288ms | FirstPageFetch=1ms | End-to-End=293ms

13:11:24:678 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:11:25:445 [Async Control] Cancelling previous pending search request via CancellationToken...

13:11:25:445 [Search Engine] Debounce settled. Executing paged query for keyword: 'น้ำำำำำำำำำำ'...

13:11:26:219 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:11:26:219 [SalesHistory Paging INIT] Keyword='น้ำำำำำำำำำำ' | TotalRows=0 | COUNT=686ms | FirstPageFetch=0ms | End-to-End=0ms

13:11:46:412 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:11:47:196 [Async Control] Cancelling previous pending search request via CancellationToken...

13:11:47:196 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:11:47:457 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:11:47:457 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=286ms | FirstPageFetch=1ms | End-to-End=291ms

13:11:48:226 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:11:49:010 [Async Control] Cancelling previous pending search request via CancellationToken...

13:11:49:010 [Search Engine] Debounce settled. Executing paged query for keyword: 'สิ่ี้้็๊๋'...

13:11:49:772 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:11:49:772 [SalesHistory Paging INIT] Keyword='สิ่ี้้็๊๋' | TotalRows=0 | COUNT=664ms | FirstPageFetch=0ms | End-to-End=0ms

13:12:10:740 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:12:11:509 [Async Control] Cancelling previous pending search request via CancellationToken...

13:12:11:509 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:12:11:756 [ClassicPaging STATS] Page=1/300000 | Fetch=2ms | End-to-End=3ms

13:12:11:756 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=307ms | FirstPageFetch=2ms | End-to-End=314ms

13:12:12:279 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:12:13:047 [Async Control] Cancelling previous pending search request via CancellationToken...

13:12:13:047 [Search Engine] Debounce settled. Executing paged query for keyword: '\u200B\u200B\u200B'...

13:12:13:557 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:12:13:557 [SalesHistory Paging INIT] Keyword='\u200B\u200B\u200B' | TotalRows=0 | COUNT=445ms | FirstPageFetch=0ms | End-to-End=0ms

13:12:28:610 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:12:29:102 [Async Control] Cancelling previous pending search request via CancellationToken...

13:12:29:102 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin\r\n[ERROR] System Hacked!'...

13:12:29:613 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:12:29:613 [SalesHistory Paging INIT] Keyword='tanin\r\n[ERROR] System Hacked!' | TotalRows=0 | COUNT=458ms | FirstPageFetch=0ms | End-to-End=0ms

13:12:41:260 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:12:42:030 [Async Control] Cancelling previous pending search request via CancellationToken...

13:12:42:030 [Search Engine] Debounce settled. Executing paged query for keyword: '..\..\..\Windows\System32'...

13:12:42:539 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:12:42:539 [SalesHistory Paging INIT] Keyword='..\..\..\Windows\System32' | TotalRows=0 | COUNT=443ms | FirstPageFetch=0ms | End-to-End=0ms

13:12:54:959 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:12:55:745 [Async Control] Cancelling previous pending search request via CancellationToken...

13:12:55:745 [Search Engine] Debounce settled. Executing paged query for keyword: '| calc.exe'...

13:12:56:271 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:13:05:569 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:13:06:355 [Async Control] Cancelling previous pending search request via CancellationToken...

13:13:06:355 [Search Engine] Debounce settled. Executing paged query for keyword: '<script>alert(1)</script>'...

13:13:06:865 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:13:06:865 [SalesHistory Paging INIT] Keyword='<script>alert(1)</script>' | TotalRows=0 | COUNT=443ms | FirstPageFetch=0ms | End-to-End=0ms

13:13:11:559 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:13:12:337 [Async Control] Cancelling previous pending search request via CancellationToken...

13:13:12:337 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:13:12:591 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:13:12:591 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=281ms | FirstPageFetch=1ms | End-to-End=286ms

13:13:15:173 [ClassicPaging STATS] Page=2/300000 | Fetch=1ms | End-to-End=3ms

13:13:15:173 [PagingBar] Navigated to page 2 | Fetch=1ms | Total=3ms

13:13:15:941 [ClassicPaging STATS] Page=3/300000 | Fetch=1ms | End-to-End=3ms

13:13:15:941 [PagingBar] Navigated to page 3 | Fetch=1ms | Total=3ms

13:13:16:725 [ClassicPaging STATS] Page=4/300000 | Fetch=1ms | End-to-End=4ms

13:13:16:725 [PagingBar] Navigated to page 4 | Fetch=1ms | Total=4ms

13:13:17:799 [ClassicPaging STATS] Page=5/300000 | Fetch=1ms | End-to-End=3ms

13:13:17:799 [PagingBar] Navigated to page 5 | Fetch=1ms | Total=3ms

13:13:18:826 [ClassicPaging STATS] Page=6/300000 | Fetch=1ms | End-to-End=3ms

13:13:18:826 [PagingBar] Navigated to page 6 | Fetch=1ms | Total=3ms

13:13:20:410 [ClassicPaging STATS] Page=300000/300000 | Fetch=5ms | End-to-End=7ms

13:13:20:410 [PagingBar] Navigated to page 300000 | Fetch=5ms | Total=7ms

13:13:23:532 [ClassicPaging STATS] Page=299999/300000 | Fetch=1ms | End-to-End=2ms

13:13:23:532 [PagingBar] Navigated to page 299999 | Fetch=1ms | Total=2ms

13:13:24:835 [ClassicPaging STATS] Page=299998/300000 | Fetch=1ms | End-to-End=3ms

13:13:24:835 [PagingBar] Navigated to page 299998 | Fetch=1ms | Total=3ms

13:13:26:150 [ClassicPaging STATS] Page=299997/300000 | Fetch=1ms | End-to-End=3ms

13:13:26:150 [PagingBar] Navigated to page 299997 | Fetch=1ms | Total=3ms

13:13:27:698 [ClassicPaging STATS] Page=299996/300000 | Fetch=1ms | End-to-End=3ms

13:13:27:698 [PagingBar] Navigated to page 299996 | Fetch=1ms | Total=3ms

13:13:29:263 [ClassicPaging STATS] Page=299995/300000 | Fetch=1ms | End-to-End=3ms

13:13:29:263 [PagingBar] Navigated to page 299995 | Fetch=1ms | Total=3ms

13:13:31:843 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=3ms

13:13:31:843 [PagingBar] Navigated to page 1 | Fetch=1ms | Total=3ms

13:13:37:570 [ClassicPaging STATS] Page=1/600000 | Fetch=4ms | End-to-End=6ms

13:13:37:570 [PagingBar] PageSize changed to 50 | Fetch=4ms | Total=6ms

13:13:39:378 [ClassicPaging STATS] Page=2/600000 | Fetch=1ms | End-to-End=3ms

13:13:39:378 [PagingBar] Navigated to page 2 | Fetch=1ms | Total=3ms

13:13:40:697 [ClassicPaging STATS] Page=3/600000 | Fetch=1ms | End-to-End=3ms

13:13:40:697 [PagingBar] Navigated to page 3 | Fetch=1ms | Total=3ms

13:13:41:987 [ClassicPaging STATS] Page=4/600000 | Fetch=1ms | End-to-End=3ms

13:13:41:987 [PagingBar] Navigated to page 4 | Fetch=1ms | Total=3ms

13:13:43:044 [ClassicPaging STATS] Page=5/600000 | Fetch=1ms | End-to-End=3ms

13:13:43:044 [PagingBar] Navigated to page 5 | Fetch=1ms | Total=3ms

13:13:44:332 [ClassicPaging STATS] Page=6/600000 | Fetch=1ms | End-to-End=3ms

13:13:44:332 [PagingBar] Navigated to page 6 | Fetch=1ms | Total=3ms

13:13:47:141 [ClassicPaging STATS] Page=600000/600000 | Fetch=1ms | End-to-End=3ms

13:13:47:141 [PagingBar] Navigated to page 600000 | Fetch=1ms | Total=3ms

13:13:49:957 [ClassicPaging STATS] Page=599999/600000 | Fetch=1ms | End-to-End=3ms

13:13:49:957 [PagingBar] Navigated to page 599999 | Fetch=1ms | Total=3ms

13:13:53:277 [ClassicPaging STATS] Page=599998/600000 | Fetch=1ms | End-to-End=3ms

13:13:53:277 [PagingBar] Navigated to page 599998 | Fetch=1ms | Total=3ms

13:13:54:567 [ClassicPaging STATS] Page=599997/600000 | Fetch=1ms | End-to-End=3ms

13:13:54:567 [PagingBar] Navigated to page 599997 | Fetch=1ms | Total=3ms

13:13:55:888 [ClassicPaging STATS] Page=599996/600000 | Fetch=1ms | End-to-End=3ms

13:13:55:888 [PagingBar] Navigated to page 599996 | Fetch=1ms | Total=3ms

13:13:56:930 [ClassicPaging STATS] Page=599995/600000 | Fetch=1ms | End-to-End=3ms

13:13:56:930 [PagingBar] Navigated to page 599995 | Fetch=1ms | Total=3ms

13:13:58:483 [ClassicPaging STATS] Page=1/600000 | Fetch=1ms | End-to-End=3ms

13:13:58:483 [PagingBar] Navigated to page 1 | Fetch=1ms | Total=3ms

13:14:00:814 [ClassicPaging STATS] Page=1/300000 | Fetch=3ms | End-to-End=4ms

13:14:00:814 [PagingBar] PageSize changed to 100 | Fetch=3ms | Total=4ms

13:15:03:369 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:04:138 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:04:138 [Search Engine] Debounce settled. Executing paged query for keyword: 'arjan best'...

13:15:04:648 [ClassicPaging STATS] Page=1/60001 | Fetch=3ms | End-to-End=4ms

13:15:04:648 [SalesHistory Paging INIT] Keyword='arjan best' | TotalRows=6,000,010 | COUNT=482ms | FirstPageFetch=3ms | End-to-End=489ms

13:15:09:886 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:10:132 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:10:639 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:10:639 [Search Engine] Debounce settled. Executing paged query for keyword: 'arjan be'...

13:15:11:150 [ClassicPaging STATS] Page=1/60001 | Fetch=1ms | End-to-End=3ms

13:15:11:150 [SalesHistory Paging INIT] Keyword='arjan be' | TotalRows=6,000,010 | COUNT=475ms | FirstPageFetch=1ms | End-to-End=482ms

13:15:12:699 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:12:960 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:13:220 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:14:005 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:14:005 [Search Engine] Debounce settled. Executing paged query for keyword: 'arja'...

13:15:14:530 [ClassicPaging STATS] Page=1/60001 | Fetch=1ms | End-to-End=3ms

13:15:14:530 [SalesHistory Paging INIT] Keyword='arja' | TotalRows=6,000,010 | COUNT=475ms | FirstPageFetch=1ms | End-to-End=481ms

13:15:16:080 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:16:866 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:16:866 [Search Engine] Debounce settled. Executing paged query for keyword: 'arj'...

13:15:17:129 [ClassicPaging STATS] Page=1/60001 | Fetch=2ms | End-to-End=4ms

13:15:17:129 [SalesHistory Paging INIT] Keyword='arj' | TotalRows=6,000,010 | COUNT=472ms | FirstPageFetch=2ms | End-to-End=479ms

13:15:19:459 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:19:983 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:19:983 [Search Engine] Debounce settled. Executing paged query for keyword: 'ar'...

13:15:20:495 [ClassicPaging STATS] Page=1/60001 | Fetch=1ms | End-to-End=3ms

13:15:20:495 [SalesHistory Paging INIT] Keyword='ar' | TotalRows=6,000,010 | COUNT=470ms | FirstPageFetch=1ms | End-to-End=476ms

13:15:21:541 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:22:325 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:22:325 [Search Engine] Debounce settled. Executing paged query for keyword: 'a'...

13:15:22:851 [ClassicPaging STATS] Page=1/60001 | Fetch=1ms | End-to-End=3ms

13:15:22:851 [SalesHistory Paging INIT] Keyword='a' | TotalRows=6,000,010 | COUNT=477ms | FirstPageFetch=1ms | End-to-End=483ms

13:15:24:385 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:25:139 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:25:139 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:15:25:385 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:15:25:385 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=283ms | FirstPageFetch=1ms | End-to-End=289ms

13:15:27:427 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:28:180 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:28:180 [Search Engine] Debounce settled. Executing paged query for keyword: 'arjan best'...

13:15:28:691 [ClassicPaging STATS] Page=1/60001 | Fetch=1ms | End-to-End=3ms

13:15:28:691 [SalesHistory Paging INIT] Keyword='arjan best' | TotalRows=6,000,010 | COUNT=477ms | FirstPageFetch=1ms | End-to-End=484ms

13:15:30:563 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:30:809 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:31:314 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:31:560 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:32:053 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:32:314 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:32:560 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:32:819 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:33:081 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:33:617 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:33:878 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:34:139 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:34:878 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:34:878 [Search Engine] Debounce settled. Executing paged query for keyword: 'arjan best ทดสอบภาษาไทย'...

13:15:35:141 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:15:35:141 [SalesHistory Paging INIT] Keyword='arjan best ทดสอบภาษาไทย' | TotalRows=0 | COUNT=463ms | FirstPageFetch=0ms | End-to-End=0ms

13:15:44:765 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:45:257 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:45:257 [Search Engine] Debounce settled. Executing paged query for keyword: 'ทดสอบภาษาไทย'...

13:15:46:016 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:15:46:016 [SalesHistory Paging INIT] Keyword='ทดสอบภาษาไทย' | TotalRows=0 | COUNT=674ms | FirstPageFetch=0ms | End-to-End=0ms

13:15:47:813 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:48:585 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:48:585 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:15:48:848 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:15:48:848 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=285ms | FirstPageFetch=1ms | End-to-End=290ms

13:15:53:762 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:54:547 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:54:547 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s.'...

13:15:54:812 [ClassicPaging STATS] Page=1/60000 | Fetch=3ms | End-to-End=4ms

13:15:54:812 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=5,999,995 | COUNT=477ms | FirstPageFetch=3ms | End-to-End=485ms

13:15:57:143 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:57:421 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:58:220 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:15:58:727 [Async Control] Cancelling previous pending search request via CancellationToken...

13:15:58:727 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s.'...

13:15:59:239 [ClassicPaging STATS] Page=1/60000 | Fetch=3ms | End-to-End=5ms

13:15:59:239 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=5,999,995 | COUNT=478ms | FirstPageFetch=3ms | End-to-End=487ms

13:16:00:022 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:00:283 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:00:544 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:00:804 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:01:064 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:01:310 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:01:554 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:01:802 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:02:060 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:02:308 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:02:552 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:03:305 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:03:305 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s. ธานินทร์ แสงงาม'...

13:16:03:801 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:16:03:801 [SalesHistory Paging INIT] Keyword='tanin s. ธานินทร์ แสงงาม' | TotalRows=0 | COUNT=461ms | FirstPageFetch=0ms | End-to-End=0ms

13:16:06:612 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:07:134 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:07:134 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:16:07:628 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:16:07:628 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=284ms | FirstPageFetch=1ms | End-to-End=289ms

13:16:13:309 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:14:094 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:14:094 [Search Engine] Debounce settled. Executing paged query for keyword: 'ibasskung ai'...

13:16:14:620 [ClassicPaging STATS] Page=1/60000 | Fetch=3ms | End-to-End=4ms

13:16:14:620 [SalesHistory Paging INIT] Keyword='ibasskung ai' | TotalRows=5,999,998 | COUNT=478ms | FirstPageFetch=3ms | End-to-End=486ms

13:16:15:664 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:15:925 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:16:709 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:16:709 [Search Engine] Debounce settled. Executing paged query for keyword: 'ibasskung ai ๗'...

13:16:17:250 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:16:17:250 [SalesHistory Paging INIT] Keyword='ibasskung ai ๗' | TotalRows=0 | COUNT=461ms | FirstPageFetch=0ms | End-to-End=0ms

13:16:17:772 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:18:032 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:18:770 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:18:770 [Search Engine] Debounce settled. Executing paged query for keyword: 'ibasskung ai'...

13:16:19:312 [ClassicPaging STATS] Page=1/60000 | Fetch=3ms | End-to-End=4ms

13:16:19:312 [SalesHistory Paging INIT] Keyword='ibasskung ai' | TotalRows=5,999,998 | COUNT=477ms | FirstPageFetch=3ms | End-to-End=485ms

13:16:19:817 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:20:618 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:20:618 [Search Engine] Debounce settled. Executing paged query for keyword: 'ibasskung ai)'...

13:16:21:130 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:16:21:130 [SalesHistory Paging INIT] Keyword='ibasskung ai)' | TotalRows=0 | COUNT=465ms | FirstPageFetch=0ms | End-to-End=0ms

13:16:23:758 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:24:512 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:24:512 [Search Engine] Debounce settled. Executing paged query for keyword: 'ibasskung ai)=='...

13:16:25:024 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:16:25:024 [SalesHistory Paging INIT] Keyword='ibasskung ai)==' | TotalRows=0 | COUNT=466ms | FirstPageFetch=0ms | End-to-End=0ms

13:16:25:546 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:26:329 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:26:329 [Search Engine] Debounce settled. Executing paged query for keyword: 'ibasskung ai)==.'...

13:16:26:839 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:16:26:839 [SalesHistory Paging INIT] Keyword='ibasskung ai)==.' | TotalRows=0 | COUNT=461ms | FirstPageFetch=0ms | End-to-End=0ms

13:16:29:449 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:30:199 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:30:460 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:31:230 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:31:230 [Search Engine] Debounce settled. Executing paged query for keyword: 'ibasskung ai)==.%*%'...

13:16:31:478 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:16:31:724 [SalesHistory Paging INIT] Keyword='ibasskung ai)==.%*%' | TotalRows=0 | COUNT=456ms | FirstPageFetch=0ms | End-to-End=0ms

13:16:36:132 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:36:909 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:36:909 [Search Engine] Debounce settled. Executing paged query for keyword: ')==.%*%'...

13:16:37:442 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:16:37:442 [SalesHistory Paging INIT] Keyword=')==.%*%' | TotalRows=0 | COUNT=445ms | FirstPageFetch=0ms | End-to-End=0ms

13:16:38:736 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:39:474 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:39:474 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:16:39:722 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:16:39:722 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=287ms | FirstPageFetch=1ms | End-to-End=293ms

13:16:45:320 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:46:121 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:46:121 [Search Engine] Debounce settled. Executing paged query for keyword: 'system bot'...

13:16:46:633 [ClassicPaging STATS] Page=1/60000 | Fetch=4ms | End-to-End=5ms

13:16:46:633 [SalesHistory Paging INIT] Keyword='system bot' | TotalRows=5,999,998 | COUNT=477ms | FirstPageFetch=4ms | End-to-End=486ms

13:16:52:577 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:53:347 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:53:347 [Search Engine] Debounce settled. Executing paged query for keyword: 'jane doe'...

13:16:53:611 [ClassicPaging STATS] Page=1/60000 | Fetch=2ms | End-to-End=4ms

13:16:53:611 [SalesHistory Paging INIT] Keyword='jane doe' | TotalRows=5,999,999 | COUNT=481ms | FirstPageFetch=2ms | End-to-End=488ms

13:16:58:744 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:16:59:514 [Async Control] Cancelling previous pending search request via CancellationToken...

13:16:59:514 [Search Engine] Debounce settled. Executing paged query for keyword: 'completed'...

13:17:00:025 [ClassicPaging STATS] Page=1/270000 | Fetch=2ms | End-to-End=3ms

13:17:00:025 [SalesHistory Paging INIT] Keyword='completed' | TotalRows=27,000,000 | COUNT=620ms | FirstPageFetch=2ms | End-to-End=626ms

13:17:05:493 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:06:016 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:06:016 [Search Engine] Debounce settled. Executing paged query for keyword: 'voided'...

13:17:06:528 [ClassicPaging STATS] Page=1/30000 | Fetch=1ms | End-to-End=2ms

13:17:06:528 [SalesHistory Paging INIT] Keyword='voided' | TotalRows=3,000,000 | COUNT=462ms | FirstPageFetch=1ms | End-to-End=468ms

13:17:16:712 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:17:495 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:17:495 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:17:17:758 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:17:17:758 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=283ms | FirstPageFetch=1ms | End-to-End=289ms

13:17:18:784 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:19:569 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:19:569 [Search Engine] Debounce settled. Executing paged query for keyword: 't'...

13:17:20:109 [ClassicPaging STATS] Page=1/60000 | Fetch=3ms | End-to-End=5ms

13:17:20:109 [SalesHistory Paging INIT] Keyword='t' | TotalRows=5,999,995 | COUNT=468ms | FirstPageFetch=3ms | End-to-End=476ms

13:17:22:692 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:23:214 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:23:214 [Search Engine] Debounce settled. Executing paged query for keyword: 'ta'...

13:17:23:741 [ClassicPaging STATS] Page=1/60000 | Fetch=3ms | End-to-End=5ms

13:17:23:741 [SalesHistory Paging INIT] Keyword='ta' | TotalRows=5,999,995 | COUNT=476ms | FirstPageFetch=3ms | End-to-End=485ms

13:17:25:583 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:25:843 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:26:626 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:26:626 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin'...

13:17:27:152 [ClassicPaging STATS] Page=1/60000 | Fetch=3ms | End-to-End=5ms

13:17:27:152 [SalesHistory Paging INIT] Keyword='tanin' | TotalRows=5,999,995 | COUNT=477ms | FirstPageFetch=3ms | End-to-End=485ms

13:17:30:528 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:30:789 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:31:311 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:31:311 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanins.'...

13:17:31:823 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:17:31:823 [SalesHistory Paging INIT] Keyword='tanins.' | TotalRows=0 | COUNT=452ms | FirstPageFetch=0ms | End-to-End=0ms

13:17:33:403 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:34:188 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:34:188 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s.'...

13:17:34:436 [ClassicPaging STATS] Page=1/60000 | Fetch=3ms | End-to-End=4ms

13:17:34:436 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=5,999,995 | COUNT=476ms | FirstPageFetch=3ms | End-to-End=484ms

13:17:36:519 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:36:795 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:37:042 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:37:299 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:37:549 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:37:810 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:38:054 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:38:314 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:39:085 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:39:085 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s. ไม่พบ'...

13:17:39:349 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:17:39:349 [SalesHistory Paging INIT] Keyword='tanin s. ไม่พบ' | TotalRows=0 | COUNT=463ms | FirstPageFetch=0ms | End-to-End=0ms

13:17:42:511 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:43:311 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:43:311 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s.'...

13:17:43:559 [ClassicPaging STATS] Page=1/60000 | Fetch=3ms | End-to-End=4ms

13:17:43:559 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=5,999,995 | COUNT=477ms | FirstPageFetch=3ms | End-to-End=484ms

13:17:45:356 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:46:125 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:46:125 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:17:46:372 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=3ms

13:17:46:372 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=293ms | FirstPageFetch=1ms | End-to-End=299ms

13:17:54:434 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:17:55:204 [Async Control] Cancelling previous pending search request via CancellationToken...

13:17:55:204 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s. not found'...

13:17:55:714 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:17:55:714 [SalesHistory Paging INIT] Keyword='tanin s. not found' | TotalRows=0 | COUNT=467ms | FirstPageFetch=0ms | End-to-End=0ms

13:18:00:905 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:18:01:413 [Async Control] Cancelling previous pending search request via CancellationToken...

13:18:01:413 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:18:01:923 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:18:01:923 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=287ms | FirstPageFetch=1ms | End-to-End=292ms

13:18:02:690 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:18:03:477 [Async Control] Cancelling previous pending search request via CancellationToken...

13:18:03:477 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s. not found'...

13:18:03:725 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:18:03:725 [SalesHistory Paging INIT] Keyword='tanin s. not found' | TotalRows=0 | COUNT=455ms | FirstPageFetch=0ms | End-to-End=0ms

13:18:05:261 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:18:06:014 [Async Control] Cancelling previous pending search request via CancellationToken...

13:18:06:014 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s.'...

13:18:06:510 [ClassicPaging STATS] Page=1/60000 | Fetch=3ms | End-to-End=4ms

13:18:06:510 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=5,999,995 | COUNT=478ms | FirstPageFetch=3ms | End-to-End=485ms

13:18:07:799 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:18:08:551 [Async Control] Cancelling previous pending search request via CancellationToken...

13:18:08:551 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:18:08:814 [ClassicPaging STATS] Page=1/300000 | Fetch=1ms | End-to-End=2ms

13:18:08:814 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=287ms | FirstPageFetch=1ms | End-to-End=293ms

13:18:17:358 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:18:18:096 [Async Control] Cancelling previous pending search request via CancellationToken...

13:18:18:096 [Search Engine] Debounce settled. Executing paged query for keyword: 'unknown_cashier_999'...

13:18:18:610 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:18:18:610 [SalesHistory Paging INIT] Keyword='unknown_cashier_999' | TotalRows=0 | COUNT=447ms | FirstPageFetch=0ms | End-to-End=0ms

13:18:25:390 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:18:25:883 [Async Control] Cancelling previous pending search request via CancellationToken...

13:18:25:883 [Search Engine] Debounce settled. Executing paged query for keyword: 'sus\'...

13:18:26:379 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:18:26:379 [SalesHistory Paging INIT] Keyword='sus\' | TotalRows=0 | COUNT=456ms | FirstPageFetch=0ms | End-to-End=0ms

13:18:32:604 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:18:33:363 [Async Control] Cancelling previous pending search request via CancellationToken...

13:18:33:363 [Search Engine] Debounce settled. Executing paged query for keyword: 'sus\test[%]_1'...

13:18:33:889 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:18:33:889 [SalesHistory Paging INIT] Keyword='sus\test[%]_1' | TotalRows=0 | COUNT=449ms | FirstPageFetch=0ms | End-to-End=0ms

13:18:34:917 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:18:35:427 [Async Control] Cancelling previous pending search request via CancellationToken...

13:18:35:427 [Search Engine] Debounce settled. Executing paged query for keyword: 'test[%]_1'...

13:18:35:938 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:18:35:938 [SalesHistory Paging INIT] Keyword='test[%]_1' | TotalRows=0 | COUNT=458ms | FirstPageFetch=0ms | End-to-End=0ms

13:18:44:196 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:18:44:986 [Async Control] Cancelling previous pending search request via CancellationToken...

13:18:44:986 [Search Engine] Debounce settled. Executing paged query for keyword: '' OR 1=1 --'...

13:18:45:730 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:18:45:730 [SalesHistory Paging INIT] Keyword='' OR 1=1 --' | TotalRows=0 | COUNT=730ms | FirstPageFetch=0ms | End-to-End=0ms

13:18:54:278 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:18:54:799 [Async Control] Cancelling previous pending search request via CancellationToken...

13:18:54:799 [Search Engine] Debounce settled. Executing paged query for keyword: '아메리카노'...

13:18:55:588 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:18:55:588 [SalesHistory Paging INIT] Keyword='아메리카노' | TotalRows=0 | COUNT=660ms | FirstPageFetch=0ms | End-to-End=0ms

13:19:11:919 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:12:689 [Async Control] Cancelling previous pending search request via CancellationToken...

13:19:12:689 [Search Engine] Debounce settled. Executing paged query for keyword: 'ชาไทย'...

13:19:13:200 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:19:13:200 [SalesHistory Paging INIT] Keyword='ชาไทย' | TotalRows=0 | COUNT=651ms | FirstPageFetch=0ms | End-to-End=0ms

13:19:16:583 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:17:105 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:17:349 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:17:870 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:18:130 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:18:391 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:19:145 [Async Control] Cancelling previous pending search request via CancellationToken...

13:19:19:145 [Search Engine] Debounce settled. Executing paged query for keyword: 'กาแฟ'...

13:19:19:934 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:19:19:934 [SalesHistory Paging INIT] Keyword='กาแฟ' | TotalRows=0 | COUNT=645ms | FirstPageFetch=0ms | End-to-End=0ms

13:19:26:464 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:26:725 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:26:986 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:27:232 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:27:478 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:27:724 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:28:001 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:28:247 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:28:507 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:28:753 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:29:014 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:29:259 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:30:012 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:30:519 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:31:027 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:31:812 [Async Control] Cancelling previous pending search request via CancellationToken...

13:19:31:812 [Search Engine] Debounce settled. Executing paged query for keyword: 'กาแฟ ไม่ได้ตั้งค่าให้ดึง'...

13:19:32:554 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:19:32:554 [SalesHistory Paging INIT] Keyword='กาแฟ ไม่ได้ตั้งค่าให้ดึง' | TotalRows=0 | COUNT=703ms | FirstPageFetch=0ms | End-to-End=0ms

13:19:37:711 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:37:970 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:38:232 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:38:738 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:39:015 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:39:783 [Async Control] Cancelling previous pending search request via CancellationToken...

13:19:39:783 [Search Engine] Debounce settled. Executing paged query for keyword: 'ดึงเฉพาะ'...

13:19:39:783 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:40:295 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:40:556 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:19:40:556 [SalesHistory Paging INIT] Keyword='ดึงเฉพาะ' | TotalRows=0 | COUNT=662ms | FirstPageFetch=0ms | End-to-End=0ms

13:19:40:556 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:40:802 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:41:326 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:41:569 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:41:817 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:42:604 [Async Control] Cancelling previous pending search request via CancellationToken...

13:19:42:604 [Search Engine] Debounce settled. Executing paged query for keyword: 'ดึงเฉพาะคอลัมน์'...

13:19:43:100 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:19:43:100 [SalesHistory Paging INIT] Keyword='ดึงเฉพาะคอลัมน์' | TotalRows=0 | COUNT=678ms | FirstPageFetch=0ms | End-to-End=0ms

13:19:46:997 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:47:243 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:47:504 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:48:011 [Async Control] Cancelling previous pending search request via CancellationToken...

13:19:48:011 [Search Engine] Debounce settled. Executing paged query for keyword: 'ดึงเฉพาะบางคอลัมน์'...

13:19:48:770 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:19:48:770 [SalesHistory Paging INIT] Keyword='ดึงเฉพาะบางคอลัมน์' | TotalRows=0 | COUNT=691ms | FirstPageFetch=0ms | End-to-End=0ms

13:19:50:830 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:19:51:630 [Async Control] Cancelling previous pending search request via CancellationToken...

13:19:51:630 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:19:51:878 [ClassicPaging STATS] Page=1/300000 | Fetch=2ms | End-to-End=3ms

13:19:51:878 [SalesHistory Paging INIT] Keyword='' | TotalRows=30,000,000 | COUNT=285ms | FirstPageFetch=2ms | End-to-End=291ms

Keywords: WinForms, C#, .NET, SQL Server, DataGridView, Pagination, Deep Pagination, Large Dataset, 30 Million Records, Enterprise Desktop Application, Performance Testing, Stress Testing, SQL Server Performance, Search Performance, iBasskung Framework

#WinForms #CSharp #DotNet #SQLServer #DataGridView #Pagination #PerformanceTesting #StressTesting #EnterpriseSoftware #SoftwareArchitecture #PerformanceEngineering #iBasskungFramework

Visual Basic .NET and C# Tutorial with Source Code

Search This Blog

Handling 30 Million Rows in C# WinForms: The Edge Cases We Chose Not to Fix