Handling 50 Million Records in C# WinForms: What the Stress Test Actually Found

iBasskung Framework — 50 Million Record Stress Test

Test date: August 25, 2026
Previous benchmark: August 19, 2026
Stack: C# WinForms + SQL Server + iBasskung Framework
Dataset: 50,000,000 records

A 50-million-row benchmark is easy to turn into a marketing headline.

It is much more useful as an engineering investigation.

This test was not designed to prove that iBasskung Framework is “the fastest” WinForms framework. The goal was to find out what actually happens when a WinForms application has to work with 50 million records.

The answer was not simply “everything is fast.”

Some parts remained remarkably stable.

Other parts became the obvious bottleneck.

And that distinction is the most valuable result of the test.

1. Test Setup

The test used a SalesHistory workflow backed by SQL Server and displayed through a WinForms application using iBasskung Framework.

The test covered:

Initial data loading
Search
Classic paging
Deep-page navigation
Page-size changes
Zero-result searches
Rapid typing
Debounce
CancellationToken
SQL injection-like inputs
Wildcard and special search patterns
Thai and other Unicode input
Emoji and unusual character sequences

The dataset contained:

50,000,000 records

With a page size of 100:

50,000,000 / 100
= 500,000 pages

The previous 30-million-record benchmark was used as a comparison point to study scaling behavior rather than looking at a single dataset size in isolation.

2. The First Important Result: We Did Not Load 50 Million Rows into WinForms

The application does not attempt to materialize the entire dataset in the UI.

The workflow is essentially:

SQL Server
    ↓
Search / COUNT
    ↓
Calculate paging information
    ↓
Fetch current page
    ↓
Display current page

Only the required page is fetched for display.

That distinction matters.

A 50-million-record database does not mean a WinForms DataGridView needs to contain 50 million visual rows.

The challenge is managing the dataset efficiently while keeping the amount of data presented to the UI small.

3. Initial Load at 50 Million Records

The first SalesHistory load produced:

TotalRows      = 50,000,000
COUNT          = 525 ms
FirstPageFetch = 7 ms
End-to-End     = 536 ms

Repeated empty searches later in the test were generally around:

COUNT          ≈ 465–491 ms
FirstPageFetch ≈ 1–2 ms

The important observation is the difference between the two operations.

The first page arrives in a few milliseconds.

The COUNT operation takes hundreds of milliseconds.

That means the primary cost of the current Classic Paging workflow is not rendering the page.

It is determining how many records exist so that the framework can calculate the total number of pages.

4. 30 Million vs 50 Million Records

The previous stress test used 30 million records.

The new test increased the dataset to 50 million.

That is:

50M / 30M ≈ 1.67×

The baseline behavior was broadly proportional to that increase.

Metric	30M Records	50M Records	Observation
Empty-search `COUNT`	~280–330 ms	~465–525 ms	Roughly proportional
Normal search `COUNT`	~470–620 ms	~760–850 ms	Generally predictable
First-page fetch	~1–8 ms	~1–9 ms	Remained in single-digit milliseconds
Wildcard/special patterns	~1.9–2.0 s	~2.8–2.9 s	Clear hotspot
Zero-result page fetch	0 ms	0 ms	Short-circuit remained effective

This is important because the entire application did not degrade uniformly as the dataset grew.

Different parts of the architecture scaled differently.

5. First-Page Fetch Stayed in the Single-Digit Milliseconds

Some representative 50-million-record searches produced:

'tanin s.'
COUNT          ≈ 766–819 ms
FirstPageFetch ≈ 5–6 ms

'arjan best'
COUNT          ≈ 767–768 ms
FirstPageFetch ≈ 1–3 ms

'completed'
TotalRows      = 45,000,000
COUNT          ≈ 842–847 ms
FirstPageFetch ≈ 3 ms

This is one of the strongest observations in the test.

Even when the result set contained millions of matching records, the application did not attempt to retrieve millions of rows for display.

It retrieved the current page.

So far, the test shows that dataset size and UI materialization size are effectively separated by the paging architecture.

6. Deep Paging Did Not Show a Performance Cliff

The 30-million-record test deliberately navigated to very deep pages.

With a page size of 100:

30,000,000 / 100
= 300,000 pages

The test reached:

Page 300,000 / 300,000
Fetch = 5 ms

It then navigated backward through several deep pages:

Page 299,999 → 1 ms
Page 299,998 → 1 ms
Page 299,997 → 1 ms
Page 299,996 → 1 ms
Page 299,995 → 1 ms

The same test also used a page size of 50:

30,000,000 / 50
= 600,000 pages

and reached:

Page 600,000 / 600,000
Fetch = 1 ms

The correct conclusion is not that pagination has mathematically proven O(1) complexity.

The benchmark does not establish that.

What it does demonstrate is:

No significant deep-page latency cliff was observed in the tested scenarios.

The current paging/query architecture handled the tested deep pages with low single-digit millisecond fetch times.

7. Search `COUNT` Became the Dominant Cost

As the dataset grew, a clear pattern emerged.

For normal searches:

COUNT          ≈ 760–850 ms
FirstPageFetch ≈ 1–7 ms

For example:

'arjan best'
TotalRows = 10,000,013
COUNT ≈ 767 ms

and:

'tanin s.'
TotalRows = 9,999,994
COUNT ≈ 819 ms

The page itself is cheap.

The count is expensive.

That changes where optimization effort should go.

At this stage, repeatedly optimizing iBasskungDataGridView rendering would not address the dominant cost shown by the benchmark.

The evidence points toward the Search/Data Access layer.

8. Zero-Result Short-Circuit Works — But Does Not Eliminate `COUNT`

The framework correctly short-circuits page retrieval when a search produces no matches.

For example:

'unknown_cashier_999'
TotalRows      = 0
FirstPageFetch = 0 ms

This is desirable because there is no reason to fetch a page after the database has already reported zero results.

However, there is an important distinction.

The short-circuit eliminates the unnecessary page fetch.

It does not eliminate the cost of determining that there are zero results in the first place.

In other words:

COUNT = expensive
FirstPageFetch = avoided

This is a different optimization problem.

9. Wildcard and Special Patterns Exposed a Reproducible Hotspot

The stress test included search patterns containing special characters such as:

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

At 50 million records, these patterns produced:

'%_%_%_%_%'
COUNT ≈ 2,883 ms

'[%]'
COUNT ≈ 2,897 ms

'[a-z]'
COUNT ≈ 2,888 ms

The same class of patterns on the 30-million-record dataset was around:

~1.94–1.96 seconds

So this behavior was reproducible across both dataset sizes.

The current evidence shows that these search patterns are substantially more expensive than ordinary searches.

However, the benchmark log alone does not prove which SQL Server execution operator is responsible.

The exact cause still needs to be established through:

SET STATISTICS IO
SET STATISTICS TIME
Actual Execution Plan

Possible factors include predicate behavior, escaping, index access, selectivity, collation, or execution-plan differences.

The important result at this stage is the observable behavior, not an unsupported explanation.

10. Unicode and Non-ASCII Search Also Deserved Attention

The test deliberately included Thai, combining characters, zero-width characters, Korean, and emoji.

Examples included:

ทดสอบภาษาไทย
กาแฟ
ชาไทย
น้ำำำำำำำำำำ
สิ่ี้้็๊๋
\u200B\u200B\u200B
🍟
아메리카노

Some of these queries produced COUNT times in the range of:

~1.8–2.0 seconds

That is materially higher than the normal ASCII search range.

This is a real and reproducible observation.

The root cause, however, should not yet be described as “Thai collation is the problem.”

Possible contributors include:

Collation behavior
Unicode string comparison
Combining-character processing
Implicit conversion
Different execution plans
Different index access
CPU-bound predicate evaluation

The next step is to compare SQL-level metrics rather than guess.

11. Security Testing Revealed a Second Performance Question

The search field was also tested with SQL injection-like inputs, including:

' OR '1'='1
'; DROP TABLE Orders; --
admin'--
' OR 1=1 --

The tested payloads did not cause the application to return the full dataset.

No unexpected page fetch occurred when the result count was zero.

This is consistent with the expected behavior of parameterized data access.

But the test also revealed a broader security lesson:

SQL Injection protection and Query Complexity protection are different problems.

A parameterized query can prevent input from becoming executable SQL syntax while still allowing a user to submit an expensive search pattern.

That means:

SQL Injection Protection
        ≠
Query Complexity Protection

For an enterprise-grade search component, both concerns are relevant.

This benchmark was not a formal penetration test, so the results should not be interpreted as a complete security audit.

12. Debounce and Cancellation During Rapid Typing

The search workflow uses:

700 ms Debounce
+
CancellationToken

During the test, users repeatedly changed the search input before the previous search had completed.

The application repeatedly logged:

[Async Control] Cancelling previous pending search request

There was also a graceful cancellation event:

[Resource Optimization] Search Task gracefully aborted

This demonstrates that the application did not simply execute every input event independently.

Rapid user input was handled as an asynchronous, cancellable workflow.

That is important for a desktop application where a user may continue typing while the previous database operation is still executing.

However, one important engineering question remains:

Does cancellation propagate all the way to the underlying SqlCommand execution?

Application-side task cancellation and database-side command cancellation are not necessarily the same thing.

That should be verified at the code level.

13. What the 50M Test Actually Proved

Based on the observed benchmark logs, the following conclusions are supported.

The dataset scaled to 50 million records

50,000,000 records

were successfully used in the test workflow.

Page retrieval remained fast

First-page fetches generally stayed within:

~1–9 ms

Deep paging remained stable in the tested scenarios

The 30M test reached hundreds of thousands of pages without a visible latency cliff.

`COUNT` became the dominant search cost

Normal searches commonly spent hundreds of milliseconds calculating the result count while the actual page fetch remained in the single-digit milliseconds.

Zero-result page retrieval was short-circuited

No unnecessary page fetch occurred after a zero-result count.

Async search behavior remained active

Debounce and cancellation continued to work during rapid typing.

Some search patterns were significantly more expensive

Wildcard, special-character, and certain Unicode inputs produced materially higher COUNT latency.

14. What the Test Did Not Prove

A good benchmark should also define its boundaries.

This test does not prove:

That pagination is mathematically O(1)
That a particular Covering Index is responsible for the observed deep-page behavior
That Collation is the sole cause of Unicode search latency
That every wildcard pattern performs a full table scan
That every possible asynchronous race condition has been eliminated
That the benchmark represents every production hardware configuration
That the application has passed a complete security audit
That the system has been validated under high concurrent multi-user load

Those are separate engineering questions.

They should be answered with additional measurements rather than assumptions.

15. The Most Important Scaling Observation: 30M → 50M

The most useful part of the benchmark is not the number 50 million by itself.

It is the comparison between 30 million and 50 million records.

The dataset grew by:

1.67×

The baseline COUNT grew by approximately the same order of magnitude.

Normal search COUNT also remained broadly predictable.

But certain search classes grew disproportionately faster.

That means the system is not simply getting “slower.”

Different workloads have different scaling characteristics.

This is exactly what capacity testing should reveal.

16. Where the Bottleneck Moved

The development history of this type of application is rarely:

Build
↓
Everything is fast
↓
Done

It is more often:

UI bottleneck
    ↓
Virtualization improvements
    ↓
Paging improvements
    ↓
Zero-result optimization
    ↓
Debounce / cancellation
    ↓
Search / COUNT becomes dominant

At 50 million records, that progression is becoming visible.

The current evidence suggests that the next optimization target is not the DataGrid rendering layer.

It is the Search/Data Access layer.

17. Classic Paging Is Not Automatically the Wrong Architecture

One obvious response to an expensive COUNT is to remove total-count-based paging entirely.

Keyset pagination, Load More, or Infinite Scroll can avoid some forms of counting.

Those approaches are valuable.

But that does not automatically mean Classic Paging should disappear.

Enterprise users may need workflows such as:

Page 1
Page 2
...
Page 350,421
...
Last Page

Direct page navigation can be useful for audit, reconciliation, sales history, reporting, and data investigation.

A more flexible architecture may support multiple strategies:

iBasskung Data Engine
│
├── Classic Paging
│   ├── TotalRows
│   ├── TotalPages
│   └── Direct Page Navigation
│
└── Keyset / Streaming Mode
    ├── No Total Count
    ├── Load More
    └── High-Volume Browsing

Another potential optimization is deferred counting:

Search
   ↓
Fetch First Page
   ↓
Display Immediately
   ↓
COUNT asynchronously
   ↓
Update Paging Information

These are architectural directions for further investigation, not conclusions from the current benchmark.

18. The Next Investigation

The next step should be to isolate the database-level cost.

At the same 50-million-record dataset, compare:

Normal ASCII search
Non-ASCII / Unicode search
Wildcard search
Bracket-pattern search
Apostrophe / adversarial input

For each query, collect:

CPU Time
Elapsed Time
Logical Reads
Physical Reads
Scan Count
Actual Execution Plan
Memory Grant
Parallelism
Warnings

This should answer a much more useful question:

Where exactly is SQL Server spending the time?

If logical reads are similar but CPU time differs significantly, the problem may be related to predicate evaluation or string comparison.

If logical reads change substantially, the execution path or access strategy may be different.

The important thing is to measure before changing the architecture.

19. What the Stress Test Actually Found

The 50-million-record benchmark did not produce a perfect result.

It produced a useful result.

50,000,000 records
        │
        ├── Page retrieval
        │      ~1–9 ms
        │
        ├── Tested deep paging
        │      No visible performance cliff
        │
        ├── Normal search COUNT
        │      ~0.7–0.85 s
        │
        └── Certain edge-case searches
               ~1.8–2.9 s

That is a much more informative picture than simply saying:

“The application can handle 50 million records.”

The application demonstrated that the current paging and page-fetch architecture can handle a very large dataset without turning the UI into a giant in-memory table.

At the same time, the benchmark exposed where the architecture starts to feel the pressure:

COUNT and search predicate execution.

Conclusion

The purpose of a stress test is not to prove that every number is fast.

It is to discover where the system begins to struggle.

At 50 million records, the current iBasskung Framework test shows that page retrieval remains in the single-digit millisecond range in the tested scenarios, while search latency is increasingly dominated by COUNT.

Certain wildcard and non-ASCII search patterns make that cost significantly higher.

That is not a failure of the test.

That is exactly what the test was supposed to reveal.

The next engineering step is therefore not to hide the numbers or redesign the entire UI.

It is to investigate the Search/Data Access layer with SQL-level evidence and optimize the bottleneck that the benchmark actually exposed.

A stress test is successful when it tells you where the system starts to struggle.

And after 50 million records, we know where to look next.

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

// Initial form load

13:21:28:741 [CONFIG] Range Set: 2022-01-01 to 2026-12-31

13:21:29:236 [ClassicPaging STATS] Page=1/500000 | Fetch=7ms | End-to-End=8ms

13:21:29:236 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=525ms | FirstPageFetch=7ms | End-to-End=536ms

13:21:31:254 [Selected Tab]: tabPage16 : 3 // Navigated to Sales History tab

13:21:33:546 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:21:34:300 [Search Engine] Debounce settled. Executing paged query for keyword: 'ค้นหาด้วยภาษาไทยจากนั้นเคลียร์ค่าใช้เวลานานกว่าการค้นหาแบบต่อเนื่อง?'...

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

13:21:36:330 [SalesHistory Paging INIT] Keyword='ค้นหาด้วยภาษาไทยจากนั้นเคลียร์ค่าใช้เวลานานกว่าการค้นหาแบบต่อเนื่อง?' | TotalRows=0 | COUNT=1949ms | FirstPageFetch=0ms | End-to-End=0ms

13:21:39:173 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:21:39:942 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:21:40:451 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:21:40:451 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=471ms | FirstPageFetch=1ms | End-to-End=475ms

13:21:48:714 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:21:48:974 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:21:49:223 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:21:49:467 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:21:49:713 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:21:50:483 [Async Control] Cancelling previous pending search request via CancellationToken...

13:21:50:483 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s'...

13:21:51:272 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=6ms

13:21:51:272 [SalesHistory Paging INIT] Keyword='tanin s' | TotalRows=9,999,994 | COUNT=771ms | FirstPageFetch=5ms | End-to-End=779ms

13:21:53:084 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:21:53:867 [Async Control] Cancelling previous pending search request via CancellationToken...

13:21:53:867 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin'...

13:21:54:656 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=7ms

13:21:54:656 [SalesHistory Paging INIT] Keyword='tanin' | TotalRows=9,999,994 | COUNT=768ms | FirstPageFetch=5ms | End-to-End=777ms

13:22:02:975 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:22:03:761 [Async Control] Cancelling previous pending search request via CancellationToken...

13:22:03:761 [Search Engine] Debounce settled. Executing paged query for keyword: 'ค้นหาด้วยภาษาไทยจากนั้นค้นหาแบบต่อเนื่องจะเร็วกว่าการเคลียร์ค่าก่อนไหม?'...

13:22:05:605 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:22:05:605 [SalesHistory Paging INIT] Keyword='ค้นหาด้วยภาษาไทยจากนั้นค้นหาแบบต่อเนื่องจะเร็วกว่าการเคลียร์ค่าก่อนไหม?' | TotalRows=0 | COUNT=1952ms | FirstPageFetch=0ms | End-to-End=0ms

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

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

13:22:16:424 [Search Engine] Debounce settled. Executing paged query for keyword: 'เร็วกว่าการเคลียร์ค่าก่อนไหม?'...

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

13:22:18:237 [SalesHistory Paging INIT] Keyword='เร็วกว่าการเคลียร์ค่าก่อนไหม?' | TotalRows=0 | COUNT=1962ms | FirstPageFetch=0ms | End-to-End=0ms

13:22:35:967 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:22:36:724 [Async Control] Cancelling previous pending search request via CancellationToken...

13:22:36:724 [Search Engine] Debounce settled. Executing paged query for keyword: '' OR '1'='1'...

13:22:38:753 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:22:38:753 [SalesHistory Paging INIT] Keyword='' OR '1'='1' | TotalRows=0 | COUNT=1941ms | FirstPageFetch=0ms | End-to-End=0ms

13:22:42:901 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:22:43:671 [Async Control] Cancelling previous pending search request via CancellationToken...

13:22:43:671 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:22:44:197 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:22:44:197 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=471ms | FirstPageFetch=1ms | End-to-End=475ms

13:22:49:052 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:22:49:806 [Async Control] Cancelling previous pending search request via CancellationToken...

13:22:49:806 [Search Engine] Debounce settled. Executing paged query for keyword: ''; DROP TABLE Orders; --'...

13:22:51:604 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:22:51:604 [SalesHistory Paging INIT] Keyword=''; DROP TABLE Orders; --' | TotalRows=0 | COUNT=1948ms | FirstPageFetch=0ms | End-to-End=0ms

13:22:58:859 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:22:59:664 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:22:59:912 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:22:59:912 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=467ms | FirstPageFetch=1ms | End-to-End=471ms

13:23:01:725 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:23:02:231 [Async Control] Cancelling previous pending search request via CancellationToken...

13:23:02:231 [Search Engine] Debounce settled. Executing paged query for keyword: 'admin'--'...

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

13:23:03:037 [SalesHistory Paging INIT] Keyword='admin'--' | TotalRows=0 | COUNT=779ms | FirstPageFetch=0ms | End-to-End=0ms

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

13:23:14:412 [Async Control] Cancelling previous pending search request via CancellationToken...

13:23:14:412 [Search Engine] Debounce settled. Executing paged query for keyword: '' OR '1'='1'...

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

13:23:16:456 [SalesHistory Paging INIT] Keyword='' OR '1'='1' | TotalRows=0 | COUNT=1890ms | FirstPageFetch=0ms | End-to-End=0ms

13:23:22:377 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:23:22:915 [Async Control] Cancelling previous pending search request via CancellationToken...

13:23:22:915 [Search Engine] Debounce settled. Executing paged query for keyword: ''; DROP TABLE Orders; --'...

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

13:23:24:968 [SalesHistory Paging INIT] Keyword=''; DROP TABLE Orders; --' | TotalRows=0 | COUNT=1935ms | FirstPageFetch=0ms | End-to-End=0ms

13:23:30:643 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:23:31:165 [Async Control] Cancelling previous pending search request via CancellationToken...

13:23:31:165 [Search Engine] Debounce settled. Executing paged query for keyword: 'admin'--'...

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

13:23:31:925 [SalesHistory Paging INIT] Keyword='admin'--' | TotalRows=0 | COUNT=780ms | FirstPageFetch=0ms | End-to-End=0ms

13:23:38:348 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:23:39:102 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:23:39:598 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:23:39:598 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=479ms | FirstPageFetch=1ms | End-to-End=483ms

13:23:40:625 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:23:41:413 [Async Control] Cancelling previous pending search request via CancellationToken...

13:23:41:413 [Search Engine] Debounce settled. Executing paged query for keyword: '%_%_%_%_%'...

13:23:44:280 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:23:44:280 [SalesHistory Paging INIT] Keyword='%_%_%_%_%' | TotalRows=0 | COUNT=2883ms | FirstPageFetch=0ms | End-to-End=0ms

13:23:55:435 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:23:56:221 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:23:56:715 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:23:56:715 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=468ms | FirstPageFetch=1ms | End-to-End=472ms

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

13:23:57:989 [Async Control] Cancelling previous pending search request via CancellationToken...

13:23:57:989 [Search Engine] Debounce settled. Executing paged query for keyword: '[%]'...

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

13:24:00:840 [SalesHistory Paging INIT] Keyword='[%]' | TotalRows=0 | COUNT=2897ms | FirstPageFetch=0ms | End-to-End=0ms

13:24:06:721 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:24:07:496 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:24:08:038 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:24:08:038 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=485ms | FirstPageFetch=1ms | End-to-End=489ms

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

13:24:11:928 [Async Control] Cancelling previous pending search request via CancellationToken...

13:24:11:928 [Search Engine] Debounce settled. Executing paged query for keyword: '[a-z]'...

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

13:24:14:763 [SalesHistory Paging INIT] Keyword='[a-z]' | TotalRows=0 | COUNT=2888ms | FirstPageFetch=0ms | End-to-End=0ms

13:24:20:177 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:24:20:931 [Async Control] Cancelling previous pending search request via CancellationToken...

13:24:20:931 [Search Engine] Debounce settled. Executing paged query for keyword: '%_%_%_%_%'...

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

13:24:23:797 [SalesHistory Paging INIT] Keyword='%_%_%_%_%' | TotalRows=0 | COUNT=2866ms | FirstPageFetch=0ms | End-to-End=0ms

13:24:28:719 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:24:29:474 [Async Control] Cancelling previous pending search request via CancellationToken...

13:24:29:474 [Search Engine] Debounce settled. Executing paged query for keyword: '[%]'...

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

13:24:32:324 [SalesHistory Paging INIT] Keyword='[%]' | TotalRows=0 | COUNT=2878ms | FirstPageFetch=0ms | End-to-End=0ms

13:24:37:979 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:24:38:760 [Async Control] Cancelling previous pending search request via CancellationToken...

13:24:38:760 [Search Engine] Debounce settled. Executing paged query for keyword: '[a-z]'...

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

13:24:41:631 [SalesHistory Paging INIT] Keyword='[a-z]' | TotalRows=0 | COUNT=2885ms | FirstPageFetch=0ms | End-to-End=0ms

13:24:52:939 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:24:53:710 [Async Control] Cancelling previous pending search request via CancellationToken...

13:24:53:710 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:24:54:235 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:24:54:235 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=467ms | FirstPageFetch=1ms | End-to-End=470ms

13:24:55:277 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:24:56:046 [Async Control] Cancelling previous pending search request via CancellationToken...

13:24:56:046 [Search Engine] Debounce settled. Executing paged query for keyword: 'sus\'...

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

13:24:56:806 [SalesHistory Paging INIT] Keyword='sus\' | TotalRows=0 | COUNT=785ms | FirstPageFetch=0ms | End-to-End=0ms

13:25:04:318 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:25:05:073 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:25:05:337 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:25:05:337 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=465ms | FirstPageFetch=1ms | End-to-End=469ms

13:25:06:381 [Debounce Input] Keystroke detected. Timer reset to 700ms.

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

13:25:06:889 [Search Engine] Debounce settled. Executing paged query for keyword: 'test\''...

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

13:25:07:679 [SalesHistory Paging INIT] Keyword='test\'' | TotalRows=0 | COUNT=785ms | FirstPageFetch=0ms | End-to-End=0ms

13:25:14:596 [Debounce Input] Keystroke detected. Timer reset to 700ms.

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

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

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

13:25:15:597 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=466ms | FirstPageFetch=1ms | End-to-End=469ms

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

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

13:25:17:120 [Search Engine] Debounce settled. Executing paged query for keyword: 'C:\Program Files\'...

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

13:25:17:893 [SalesHistory Paging INIT] Keyword='C:\Program Files\' | TotalRows=0 | COUNT=778ms | FirstPageFetch=0ms | End-to-End=0ms

13:25:24:298 [Debounce Input] Keystroke detected. Timer reset to 700ms.

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

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

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

13:25:25:873 [SalesHistory Paging INIT] Keyword='sus\' | TotalRows=0 | COUNT=792ms | FirstPageFetch=0ms | End-to-End=0ms

13:25:31:495 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:25:32:019 [Async Control] Cancelling previous pending search request via CancellationToken...

13:25:32:019 [Search Engine] Debounce settled. Executing paged query for keyword: 'test\''...

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

13:25:32:794 [SalesHistory Paging INIT] Keyword='test\'' | TotalRows=0 | COUNT=782ms | FirstPageFetch=0ms | End-to-End=0ms

13:25:39:247 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:25:40:051 [Async Control] Cancelling previous pending search request via CancellationToken...

13:25:40:051 [Search Engine] Debounce settled. Executing paged query for keyword: 'C:\Program Files\'...

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

13:25:40:794 [SalesHistory Paging INIT] Keyword='C:\Program Files\' | TotalRows=0 | COUNT=785ms | FirstPageFetch=0ms | End-to-End=0ms

13:25:49:076 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:25:49:600 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:25:50:111 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:25:50:111 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=470ms | FirstPageFetch=1ms | End-to-End=474ms

13:25:54:747 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:25:55:516 [Async Control] Cancelling previous pending search request via CancellationToken...

13:25:55:516 [Search Engine] Debounce settled. Executing paged query for keyword: '& UI DoS

13:25:55:516 น้ำำำำำำำำำำ'...

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

13:25:56:291 [SalesHistory Paging INIT] Keyword='& UI DoS

13:25:56:291 น้ำำำำำำำำำำ' | TotalRows=0 | COUNT=768ms | FirstPageFetch=0ms | End-to-End=0ms

13:26:03:761 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:26:04:512 [Async Control] Cancelling previous pending search request via CancellationToken...

13:26:04:512 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:26:05:031 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:26:05:031 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=470ms | FirstPageFetch=1ms | End-to-End=474ms

13:26:06:851 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:26:07:620 [Async Control] Cancelling previous pending search request via CancellationToken...

13:26:07:620 [Search Engine] Debounce settled. Executing paged query for keyword: 'น้ำำำำำำำำำำ'...

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

13:26:09:448 [SalesHistory Paging INIT] Keyword='น้ำำำำำำำำำำ' | TotalRows=0 | COUNT=1955ms | FirstPageFetch=0ms | End-to-End=0ms

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

13:26:27:510 [Async Control] Cancelling previous pending search request via CancellationToken...

13:26:27:510 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:26:28:036 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:26:28:036 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=472ms | FirstPageFetch=1ms | End-to-End=475ms

13:26:29:867 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:26:30:636 [Async Control] Cancelling previous pending search request via CancellationToken...

13:26:30:636 [Search Engine] Debounce settled. Executing paged query for keyword: 'สิ่ี้้็๊๋'...

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

13:26:32:465 [SalesHistory Paging INIT] Keyword='สิ่ี้้็๊๋' | TotalRows=0 | COUNT=1902ms | FirstPageFetch=0ms | End-to-End=0ms

13:26:39:719 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:26:40:504 [Async Control] Cancelling previous pending search request via CancellationToken...

13:26:40:504 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:26:40:752 [ClassicPaging STATS] Page=1/500000 | Fetch=2ms | End-to-End=3ms

13:26:40:752 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=472ms | FirstPageFetch=2ms | End-to-End=477ms

13:26:42:042 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:26:42:550 [Async Control] Cancelling previous pending search request via CancellationToken...

13:26:42:550 [Search Engine] Debounce settled. Executing paged query for keyword: '\u200B\u200B\u200B'...

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

13:26:43:325 [SalesHistory Paging INIT] Keyword='\u200B\u200B\u200B' | TotalRows=0 | COUNT=768ms | FirstPageFetch=0ms | End-to-End=0ms

13:26:50:302 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:26:51:071 [Async Control] Cancelling previous pending search request via CancellationToken...

13:26:51:071 [Search Engine] Debounce settled. Executing paged query for keyword: 'น้ำำำำำำำำำำ'...

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

13:26:52:884 [SalesHistory Paging INIT] Keyword='น้ำำำำำำำำำำ' | TotalRows=0 | COUNT=1916ms | FirstPageFetch=0ms | End-to-End=0ms

13:27:02:428 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:27:03:211 [Async Control] Cancelling previous pending search request via CancellationToken...

13:27:03:211 [Search Engine] Debounce settled. Executing paged query for keyword: 'สิ่ี้้็๊๋'...

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

13:27:05:271 [SalesHistory Paging INIT] Keyword='สิ่ี้้็๊๋' | TotalRows=0 | COUNT=1951ms | FirstPageFetch=0ms | End-to-End=0ms

13:27:20:329 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:27:21:128 [Async Control] Cancelling previous pending search request via CancellationToken...

13:27:21:128 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:27:21:653 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:27:21:653 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=470ms | FirstPageFetch=1ms | End-to-End=474ms

13:27:22:666 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:27:23:436 [Async Control] Cancelling previous pending search request via CancellationToken...

13:27:23:436 [Search Engine] Debounce settled. Executing paged query for keyword: 'สิ่ี้้็๊๋'...

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

13:27:25:233 [SalesHistory Paging INIT] Keyword='สิ่ี้้็๊๋' | TotalRows=0 | COUNT=1907ms | FirstPageFetch=0ms | End-to-End=0ms

13:27:26:015 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:27:26:799 [Async Control] Cancelling previous pending search request via CancellationToken...

13:27:26:799 [Search Engine] Debounce settled. Executing paged query for keyword: 'สิ่ี้้็๊๋dd'...

13:27:28:597 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:27:28:597 [SalesHistory Paging INIT] Keyword='สิ่ี้้็๊๋dd' | TotalRows=0 | COUNT=1880ms | FirstPageFetch=0ms | End-to-End=0ms

13:27:30:410 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:27:30:930 [Async Control] Cancelling previous pending search request via CancellationToken...

13:27:30:930 [Search Engine] Debounce settled. Executing paged query for keyword: 'สิ่ี้้็๊๋'...

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

13:27:33:006 [SalesHistory Paging INIT] Keyword='สิ่ี้้็๊๋' | TotalRows=0 | COUNT=1915ms | FirstPageFetch=0ms | End-to-End=0ms

13:27:38:936 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:27:39:737 [Async Control] Cancelling previous pending search request via CancellationToken...

13:27:39:737 [Search Engine] Debounce settled. Executing paged query for keyword: '\u200B\u200B\u200B'...

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

13:27:40:510 [SalesHistory Paging INIT] Keyword='\u200B\u200B\u200B' | TotalRows=0 | COUNT=792ms | FirstPageFetch=0ms | End-to-End=0ms

13:27:48:228 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:27:48:980 [Async Control] Cancelling previous pending search request via CancellationToken...

13:27:48:980 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin\r\n[ERROR] System Hacked!'...

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

13:27:49:785 [SalesHistory Paging INIT] Keyword='tanin\r\n[ERROR] System Hacked!' | TotalRows=0 | COUNT=777ms | FirstPageFetch=0ms | End-to-End=0ms

13:27:58:864 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:27:59:649 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:28:00:144 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:28:00:144 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=468ms | FirstPageFetch=1ms | End-to-End=471ms

13:28:01:435 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:28:01:974 [Async Control] Cancelling previous pending search request via CancellationToken...

13:28:01:974 [Search Engine] Debounce settled. Executing paged query for keyword: '..\..\..\Windows\System32'...

13:28:02:733 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:28:02:733 [SalesHistory Paging INIT] Keyword='..\..\..\Windows\System32' | TotalRows=0 | COUNT=778ms | FirstPageFetch=0ms | End-to-End=0ms

13:28:08:632 [Debounce Input] Keystroke detected. Timer reset to 700ms.

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

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

13:28:09:940 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:28:09:940 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=472ms | FirstPageFetch=1ms | End-to-End=477ms

13:28:10:709 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:28:11:229 [Async Control] Cancelling previous pending search request via CancellationToken...

13:28:11:229 [Search Engine] Debounce settled. Executing paged query for keyword: '| calc.exe'...

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

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

13:28:20:215 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:28:20:726 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:28:20:726 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=469ms | FirstPageFetch=1ms | End-to-End=473ms

13:28:21:755 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:28:22:556 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:28:23:299 [ClassicPaging STATS] Page=1/0 | Fetch=0ms | End-to-End=0ms

13:28:23:299 [SalesHistory Paging INIT] Keyword='<script>alert(1)</script>' | TotalRows=0 | COUNT=771ms | FirstPageFetch=0ms | End-to-End=0ms

13:28:30:432 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:28:31:217 [Async Control] Cancelling previous pending search request via CancellationToken...

13:28:31:217 [Search Engine] Debounce settled. Executing paged query for keyword: '..\..\..\Windows\System32'...

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

13:28:31:991 [SalesHistory Paging INIT] Keyword='..\..\..\Windows\System32' | TotalRows=0 | COUNT=765ms | FirstPageFetch=0ms | End-to-End=0ms

13:28:37:679 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:28:38:433 [Async Control] Cancelling previous pending search request via CancellationToken...

13:28:38:433 [Search Engine] Debounce settled. Executing paged query for keyword: '| calc.exe'...

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

13:28:45:104 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:28:45:888 [Async Control] Cancelling previous pending search request via CancellationToken...

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

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

13:28:46:647 [SalesHistory Paging INIT] Keyword='<script>alert(1)</script>' | TotalRows=0 | COUNT=775ms | FirstPageFetch=0ms | End-to-End=0ms

13:30:34:886 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:30:35:657 [Async Control] Cancelling previous pending search request via CancellationToken...

13:30:35:657 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:30:36:168 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:30:36:168 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=483ms | FirstPageFetch=1ms | End-to-End=488ms

13:30:37:196 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:30:37:968 [Async Control] Cancelling previous pending search request via CancellationToken...

13:30:37:968 [Search Engine] Debounce settled. Executing paged query for keyword: 'arjan best'...

13:30:38:726 [ClassicPaging STATS] Page=1/100001 | Fetch=3ms | End-to-End=5ms

13:30:38:726 [SalesHistory Paging INIT] Keyword='arjan best' | TotalRows=10,000,013 | COUNT=767ms | FirstPageFetch=3ms | End-to-End=774ms

13:31:10:627 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:31:11:139 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:31:11:634 [ClassicPaging STATS] Page=1/500000 | Fetch=2ms | End-to-End=4ms

13:31:11:634 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=491ms | FirstPageFetch=2ms | End-to-End=497ms

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

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

13:31:13:432 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s.'...

13:31:14:197 [ClassicPaging STATS] Page=1/100000 | Fetch=6ms | End-to-End=8ms

13:31:14:197 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=9,999,994 | COUNT=819ms | FirstPageFetch=6ms | End-to-End=829ms

13:31:21:160 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:31:21:943 [Async Control] Cancelling previous pending search request via CancellationToken...

13:31:21:943 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:31:22:468 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:31:22:468 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=465ms | FirstPageFetch=1ms | End-to-End=469ms

13:31:24:017 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:31:24:788 [Async Control] Cancelling previous pending search request via CancellationToken...

13:31:24:788 [Search Engine] Debounce settled. Executing paged query for keyword: 'ibasskung ai'...

13:31:25:576 [ClassicPaging STATS] Page=1/100000 | Fetch=3ms | End-to-End=6ms

13:31:25:576 [SalesHistory Paging INIT] Keyword='ibasskung ai' | TotalRows=9,999,997 | COUNT=769ms | FirstPageFetch=3ms | End-to-End=777ms

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

13:31:33:405 [Async Control] Cancelling previous pending search request via CancellationToken...

13:31:33:405 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:31:33:668 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:31:33:668 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=466ms | FirstPageFetch=1ms | End-to-End=471ms

13:31:34:422 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:31:35:175 [Async Control] Cancelling previous pending search request via CancellationToken...

13:31:35:175 [Search Engine] Debounce settled. Executing paged query for keyword: 'system bot'...

13:31:35:949 [ClassicPaging STATS] Page=1/100000 | Fetch=7ms | End-to-End=9ms

13:31:35:949 [SalesHistory Paging INIT] Keyword='system bot' | TotalRows=9,999,997 | COUNT=770ms | FirstPageFetch=7ms | End-to-End=780ms

13:31:42:664 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:31:43:188 [Async Control] Cancelling previous pending search request via CancellationToken...

13:31:43:188 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:31:43:715 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:31:43:715 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=467ms | FirstPageFetch=1ms | End-to-End=471ms

13:31:44:499 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:31:45:269 [Async Control] Cancelling previous pending search request via CancellationToken...

13:31:45:269 [Search Engine] Debounce settled. Executing paged query for keyword: 'jane doe'...

13:31:46:028 [ClassicPaging STATS] Page=1/100000 | Fetch=4ms | End-to-End=5ms

13:31:46:028 [SalesHistory Paging INIT] Keyword='jane doe' | TotalRows=9,999,999 | COUNT=775ms | FirstPageFetch=4ms | End-to-End=783ms

13:31:53:019 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:31:53:774 [Async Control] Cancelling previous pending search request via CancellationToken...

13:31:53:774 [Search Engine] Debounce settled. Executing paged query for keyword: 'arjan best'...

13:31:54:548 [ClassicPaging STATS] Page=1/100001 | Fetch=1ms | End-to-End=2ms

13:31:54:548 [SalesHistory Paging INIT] Keyword='arjan best' | TotalRows=10,000,013 | COUNT=768ms | FirstPageFetch=1ms | End-to-End=772ms

13:32:00:460 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:32:00:966 [Async Control] Cancelling previous pending search request via CancellationToken...

13:32:00:966 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s.'...

13:32:01:756 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=7ms

13:32:01:756 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=9,999,994 | COUNT=765ms | FirstPageFetch=5ms | End-to-End=774ms

13:32:07:748 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:32:08:287 [Async Control] Cancelling previous pending search request via CancellationToken...

13:32:08:287 [Search Engine] Debounce settled. Executing paged query for keyword: 'ibasskung ai'...

13:32:09:047 [ClassicPaging STATS] Page=1/100000 | Fetch=3ms | End-to-End=4ms

13:32:09:047 [SalesHistory Paging INIT] Keyword='ibasskung ai' | TotalRows=9,999,997 | COUNT=784ms | FirstPageFetch=3ms | End-to-End=790ms

13:32:14:927 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:32:15:666 [Async Control] Cancelling previous pending search request via CancellationToken...

13:32:15:666 [Search Engine] Debounce settled. Executing paged query for keyword: 'system bot'...

13:32:16:440 [ClassicPaging STATS] Page=1/100000 | Fetch=7ms | End-to-End=8ms

13:32:16:440 [SalesHistory Paging INIT] Keyword='system bot' | TotalRows=9,999,997 | COUNT=768ms | FirstPageFetch=7ms | End-to-End=778ms

13:32:22:049 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:32:22:802 [Async Control] Cancelling previous pending search request via CancellationToken...

13:32:22:802 [Search Engine] Debounce settled. Executing paged query for keyword: 'jane doe'...

13:32:23:545 [ClassicPaging STATS] Page=1/100000 | Fetch=4ms | End-to-End=6ms

13:32:23:545 [SalesHistory Paging INIT] Keyword='jane doe' | TotalRows=9,999,999 | COUNT=771ms | FirstPageFetch=4ms | End-to-End=778ms

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

13:33:05:992 [Async Control] Cancelling previous pending search request via CancellationToken...

13:33:05:992 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:33:06:255 [ClassicPaging STATS] Page=1/500000 | Fetch=2ms | End-to-End=3ms

13:33:06:255 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=478ms | FirstPageFetch=2ms | End-to-End=483ms

13:33:07:835 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:08:344 [Async Control] Cancelling previous pending search request via CancellationToken...

13:33:08:344 [Search Engine] Debounce settled. Executing paged query for keyword: 'completed'...

13:33:09:380 [ClassicPaging STATS] Page=1/450000 | Fetch=3ms | End-to-End=4ms

13:33:09:380 [SalesHistory Paging INIT] Keyword='completed' | TotalRows=45,000,000 | COUNT=847ms | FirstPageFetch=3ms | End-to-End=853ms

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

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

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

13:33:16:886 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=3ms

13:33:16:886 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=468ms | FirstPageFetch=1ms | End-to-End=472ms

13:33:18:166 [Debounce Input] Keystroke detected. Timer reset to 700ms.

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

13:33:18:667 [Search Engine] Debounce settled. Executing paged query for keyword: 'voided'...

13:33:19:457 [ClassicPaging STATS] Page=1/50000 | Fetch=1ms | End-to-End=5ms

13:33:19:457 [SalesHistory Paging INIT] Keyword='voided' | TotalRows=5,000,000 | COUNT=784ms | FirstPageFetch=1ms | End-to-End=791ms

13:33:25:106 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:25:891 [Async Control] Cancelling previous pending search request via CancellationToken...

13:33:25:891 [Search Engine] Debounce settled. Executing paged query for keyword: 'completed'...

13:33:26:635 [ClassicPaging STATS] Page=1/450000 | Fetch=3ms | End-to-End=5ms

13:33:26:635 [SalesHistory Paging INIT] Keyword='completed' | TotalRows=45,000,000 | COUNT=842ms | FirstPageFetch=3ms | End-to-End=849ms

13:33:30:947 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:31:713 [Async Control] Cancelling previous pending search request via CancellationToken...

13:33:31:713 [Search Engine] Debounce settled. Executing paged query for keyword: 'voided'...

13:33:32:472 [ClassicPaging STATS] Page=1/50000 | Fetch=1ms | End-to-End=2ms

13:33:32:472 [SalesHistory Paging INIT] Keyword='voided' | TotalRows=5,000,000 | COUNT=782ms | FirstPageFetch=1ms | End-to-End=786ms

13:33:39:173 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:39:925 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:33:40:435 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=3ms

13:33:40:435 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=471ms | FirstPageFetch=1ms | End-to-End=475ms

13:33:42:539 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:43:308 [Async Control] Cancelling previous pending search request via CancellationToken...

13:33:43:308 [Search Engine] Debounce settled. Executing paged query for keyword: 't'...

13:33:44:114 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=7ms

13:33:44:114 [SalesHistory Paging INIT] Keyword='t' | TotalRows=9,999,994 | COUNT=760ms | FirstPageFetch=5ms | End-to-End=769ms

13:33:45:923 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:46:416 [Async Control] Cancelling previous pending search request via CancellationToken...

13:33:46:416 [Search Engine] Debounce settled. Executing paged query for keyword: 'ta'...

13:33:47:176 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=7ms

13:33:47:176 [SalesHistory Paging INIT] Keyword='ta' | TotalRows=9,999,994 | COUNT=770ms | FirstPageFetch=5ms | End-to-End=779ms

13:33:47:960 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:48:715 [Async Control] Cancelling previous pending search request via CancellationToken...

13:33:48:715 [Search Engine] Debounce settled. Executing paged query for keyword: 'tan'...

13:33:49:506 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=7ms

13:33:49:506 [SalesHistory Paging INIT] Keyword='tan' | TotalRows=9,999,994 | COUNT=765ms | FirstPageFetch=5ms | End-to-End=775ms

13:33:50:810 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:51:594 [Async Control] Cancelling previous pending search request via CancellationToken...

13:33:51:594 [Search Engine] Debounce settled. Executing paged query for keyword: 'tani'...

13:33:52:352 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=8ms

13:33:52:352 [SalesHistory Paging INIT] Keyword='tani' | TotalRows=9,999,994 | COUNT=773ms | FirstPageFetch=5ms | End-to-End=783ms

13:33:53:381 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:54:181 [Async Control] Cancelling previous pending search request via CancellationToken...

13:33:54:181 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin'...

13:33:54:955 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=7ms

13:33:54:955 [SalesHistory Paging INIT] Keyword='tanin' | TotalRows=9,999,994 | COUNT=771ms | FirstPageFetch=5ms | End-to-End=780ms

13:33:55:751 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:56:012 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:56:798 [Async Control] Cancelling previous pending search request via CancellationToken...

13:33:56:798 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s'...

13:33:57:556 [ClassicPaging STATS] Page=1/100000 | Fetch=9ms | End-to-End=10ms

13:33:57:556 [SalesHistory Paging INIT] Keyword='tanin s' | TotalRows=9,999,994 | COUNT=779ms | FirstPageFetch=9ms | End-to-End=791ms

13:33:58:306 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:33:58:845 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:33:59:620 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=7ms

13:33:59:620 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=9,999,994 | COUNT=766ms | FirstPageFetch=5ms | End-to-End=775ms

13:34:01:171 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:01:955 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:34:02:480 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:34:02:480 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=465ms | FirstPageFetch=1ms | End-to-End=469ms

13:34:03:003 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:03:265 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:03:771 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:03:771 [Search Engine] Debounce settled. Executing paged query for keyword: 'ta'...

13:34:04:530 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=7ms

13:34:04:530 [SalesHistory Paging INIT] Keyword='ta' | TotalRows=9,999,994 | COUNT=768ms | FirstPageFetch=5ms | End-to-End=777ms

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

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

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

13:34:06:097 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin'...

13:34:07:118 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=8ms

13:34:07:118 [SalesHistory Paging INIT] Keyword='tanin' | TotalRows=9,999,994 | COUNT=766ms | FirstPageFetch=5ms | End-to-End=775ms

13:34:07:641 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:07:888 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:08:672 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:34:09:416 [ClassicPaging STATS] Page=1/100000 | Fetch=5ms | End-to-End=7ms

13:34:09:416 [SalesHistory Paging INIT] Keyword='tanin s.' | TotalRows=9,999,994 | COUNT=778ms | FirstPageFetch=5ms | End-to-End=787ms

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

13:34:11:475 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:34:11:984 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=3ms

13:34:11:984 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=473ms | FirstPageFetch=1ms | End-to-End=477ms

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

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

13:34:19:272 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s. not found'...

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

13:34:20:031 [SalesHistory Paging INIT] Keyword='tanin s. not found' | TotalRows=0 | COUNT=795ms | FirstPageFetch=0ms | End-to-End=0ms

13:34:22:412 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:22:672 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:22:919 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:23:179 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:23:424 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:23:916 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:23:916 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s. ไม่พบอ'...

13:34:24:179 [Debounce Input] Keystroke detected. Timer reset to 700ms.

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

13:34:24:954 [SalesHistory Paging INIT] Keyword='tanin s. ไม่พบอ' | TotalRows=0 | COUNT=790ms | FirstPageFetch=0ms | End-to-End=0ms

13:34:24:954 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:24:954 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s. ไม่พบ'...

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

13:34:25:744 [SalesHistory Paging INIT] Keyword='tanin s. ไม่พบ' | TotalRows=0 | COUNT=797ms | FirstPageFetch=0ms | End-to-End=0ms

13:34:28:109 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:28:909 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:28:909 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:34:29:433 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:34:29:433 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=469ms | FirstPageFetch=1ms | End-to-End=474ms

13:34:29:941 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:30:724 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:30:724 [Search Engine] Debounce settled. Executing paged query for keyword: 'tanin s. ไม่พบ'...

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

13:34:31:484 [SalesHistory Paging INIT] Keyword='tanin s. ไม่พบ' | TotalRows=0 | COUNT=796ms | FirstPageFetch=0ms | End-to-End=0ms

13:34:37:692 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:38:463 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:38:463 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:34:38:727 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:34:38:727 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=466ms | FirstPageFetch=1ms | End-to-End=470ms

13:34:39:219 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:40:007 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:40:007 [Search Engine] Debounce settled. Executing paged query for keyword: 'unknown_cashier_999'...

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

13:34:40:797 [SalesHistory Paging INIT] Keyword='unknown_cashier_999' | TotalRows=0 | COUNT=773ms | FirstPageFetch=0ms | End-to-End=0ms

13:34:42:088 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:42:338 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:42:593 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:43:362 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:43:362 [Search Engine] Debounce settled. Executing paged query for keyword: 'unknown_cashier'...

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

13:34:44:151 [SalesHistory Paging INIT] Keyword='unknown_cashier' | TotalRows=0 | COUNT=777ms | FirstPageFetch=0ms | End-to-End=0ms

13:34:44:688 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:44:949 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:45:198 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:45:470 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:45:715 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:46:221 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:46:221 [Search Engine] Debounce settled. Executing paged query for keyword: 'unknown_'...

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

13:34:47:242 [SalesHistory Paging INIT] Keyword='unknown_' | TotalRows=0 | COUNT=775ms | FirstPageFetch=0ms | End-to-End=0ms

13:34:48:302 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:49:042 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:49:042 [Search Engine] Debounce settled. Executing paged query for keyword: 'unknown_cashier_999'...

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

13:34:49:830 [SalesHistory Paging INIT] Keyword='unknown_cashier_999' | TotalRows=0 | COUNT=782ms | FirstPageFetch=0ms | End-to-End=0ms

13:34:55:765 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:56:535 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:56:535 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:34:56:798 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:34:56:798 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=465ms | FirstPageFetch=1ms | End-to-End=469ms

13:34:57:319 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:34:58:074 [Async Control] Cancelling previous pending search request via CancellationToken...

13:34:58:074 [Search Engine] Debounce settled. Executing paged query for keyword: 'sus\'...

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

13:34:58:848 [SalesHistory Paging INIT] Keyword='sus\' | TotalRows=0 | COUNT=782ms | FirstPageFetch=0ms | End-to-End=0ms

13:35:04:227 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:04:983 [Async Control] Cancelling previous pending search request via CancellationToken...

13:35:04:983 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:35:05:231 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:35:05:231 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=470ms | FirstPageFetch=1ms | End-to-End=474ms

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

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

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

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

13:35:07:329 [SalesHistory Paging INIT] Keyword='test[%]_1' | TotalRows=0 | COUNT=786ms | FirstPageFetch=0ms | End-to-End=0ms

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

13:35:14:354 [Async Control] Cancelling previous pending search request via CancellationToken...

13:35:14:354 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:35:14:865 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:35:14:865 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=466ms | FirstPageFetch=1ms | End-to-End=470ms

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

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

13:35:16:417 [Search Engine] Debounce settled. Executing paged query for keyword: '' OR 1=1 --'...

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

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

13:35:24:419 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:24:927 [Async Control] Cancelling previous pending search request via CancellationToken...

13:35:24:927 [Search Engine] Debounce settled. Executing paged query for keyword: 'sus\'...

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

13:35:25:950 [SalesHistory Paging INIT] Keyword='sus\' | TotalRows=0 | COUNT=783ms | FirstPageFetch=0ms | End-to-End=0ms

13:35:33:141 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:33:910 [Async Control] Cancelling previous pending search request via CancellationToken...

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

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

13:35:34:688 [SalesHistory Paging INIT] Keyword='test[%]_1' | TotalRows=0 | COUNT=800ms | FirstPageFetch=0ms | End-to-End=0ms

13:35:40:294 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:41:050 [Async Control] Cancelling previous pending search request via CancellationToken...

13:35:41:050 [Search Engine] Debounce settled. Executing paged query for keyword: '' OR 1=1 --'...

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

13:35:42:847 [SalesHistory Paging INIT] Keyword='' OR 1=1 --' | TotalRows=0 | COUNT=1926ms | FirstPageFetch=0ms | End-to-End=0ms

13:35:50:035 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:50:836 [Async Control] Cancelling previous pending search request via CancellationToken...

13:35:50:836 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:35:51:084 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:35:51:084 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=466ms | FirstPageFetch=1ms | End-to-End=470ms

13:35:51:869 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:52:641 [Async Control] Cancelling previous pending search request via CancellationToken...

13:35:52:641 [Search Engine] Debounce settled. Executing paged query for keyword: '아메리카노'...

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

13:35:54:454 [SalesHistory Paging INIT] Keyword='아메리카노' | TotalRows=0 | COUNT=1901ms | FirstPageFetch=0ms | End-to-End=0ms

13:35:55:787 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:56:299 [Async Control] Cancelling previous pending search request via CancellationToken...

13:35:56:299 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:35:56:795 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:35:56:795 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=481ms | FirstPageFetch=1ms | End-to-End=485ms

13:35:57:580 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:58:072 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:58:580 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:58:841 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:59:088 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:59:350 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:59:594 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:35:59:839 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:00:101 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:00:347 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:00:838 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:01:594 [Async Control] Cancelling previous pending search request via CancellationToken...

13:36:01:594 [Search Engine] Debounce settled. Executing paged query for keyword: 'ชา ไทย กา แฟ'...

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

13:36:03:407 [SalesHistory Paging INIT] Keyword='ชา ไทย กา แฟ' | TotalRows=0 | COUNT=1942ms | FirstPageFetch=0ms | End-to-End=0ms

13:36:04:725 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:04:971 [Debounce Input] Keystroke detected. Timer reset to 700ms.

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

13:36:05:724 [Async Control] Cancelling previous pending search request via CancellationToken...

13:36:05:724 [Search Engine] Debounce settled. Executing paged query for keyword: 'กาแฟ'...

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

13:36:07:801 [SalesHistory Paging INIT] Keyword='กาแฟ' | TotalRows=0 | COUNT=1923ms | FirstPageFetch=0ms | End-to-End=0ms

13:36:10:903 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:11:688 [Async Control] Cancelling previous pending search request via CancellationToken...

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

13:36:12:214 [ClassicPaging STATS] Page=1/500000 | Fetch=2ms | End-to-End=3ms

13:36:12:214 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=467ms | FirstPageFetch=2ms | End-to-End=472ms

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

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

13:36:18:136 [Search Engine] Debounce settled. Executing paged query for keyword: '🍟'...

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

13:36:19:933 [SalesHistory Paging INIT] Keyword='🍟' | TotalRows=0 | COUNT=1832ms | FirstPageFetch=0ms | End-to-End=0ms

13:36:21:256 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:21:518 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:21:765 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:22:010 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:22:272 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:22:516 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:22:761 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:23:546 [Async Control] Cancelling previous pending search request via CancellationToken...

13:36:23:546 [Search Engine] Debounce settled. Executing paged query for keyword: '🍟 ชาไทย'...

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

13:36:25:358 [SalesHistory Paging INIT] Keyword='🍟 ชาไทย' | TotalRows=0 | COUNT=1918ms | FirstPageFetch=0ms | End-to-End=0ms

13:36:25:882 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:26:145 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:26:390 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:27:143 [Async Control] Cancelling previous pending search request via CancellationToken...

13:36:27:143 [Search Engine] Debounce settled. Executing paged query for keyword: '🍟'...

13:36:27:143 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:27:391 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:28:166 [Async Control] Cancelling previous pending search request via CancellationToken...

13:36:28:166 [Search Engine] Debounce settled. Executing paged query for keyword: '🍟 tea'...

13:36:28:166 [Resource Optimization] Search Task gracefully aborted for: '🍟' (User continued typing)

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

13:36:30:242 [SalesHistory Paging INIT] Keyword='🍟 tea' | TotalRows=0 | COUNT=2013ms | FirstPageFetch=0ms | End-to-End=0ms

13:36:30:242 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:30:489 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:30:751 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:31:551 [Async Control] Cancelling previous pending search request via CancellationToken...

13:36:31:551 [Search Engine] Debounce settled. Executing paged query for keyword: '🍟 thai tea'...

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

13:36:33:363 [SalesHistory Paging INIT] Keyword='🍟 thai tea' | TotalRows=0 | COUNT=1886ms | FirstPageFetch=0ms | End-to-End=0ms

13:36:33:885 [Debounce Input] Keystroke detected. Timer reset to 700ms.

13:36:34:640 [Async Control] Cancelling previous pending search request via CancellationToken...

13:36:34:640 [Search Engine] Debounce settled. Executing paged query for keyword: ''...

13:36:35:151 [ClassicPaging STATS] Page=1/500000 | Fetch=1ms | End-to-End=2ms

13:36:35:151 [SalesHistory Paging INIT] Keyword='' | TotalRows=50,000,000 | COUNT=468ms | FirstPageFetch=1ms | End-to-End=473ms

This article is part of the ongoing engineering and performance work behind iBasskung Framework, a commercial-grade C# WinForms application foundation focused on enterprise workflows, high-volume data handling, multilingual UI, and long-term desktop application engineering.

Keywords: WinForms, C#, .NET, SQL Server, DataGridView, Pagination, Deep Pagination, Large Dataset, 50 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

We Stress Tested 50 Million Records in C# WinForms. Here is What Broke

Handling 50 Million Records in C# WinForms: What the Stress Test Actually Found

1. Test Setup

2. The First Important Result: We Did Not Load 50 Million Rows into WinForms

3. Initial Load at 50 Million Records

4. 30 Million vs 50 Million Records

5. First-Page Fetch Stayed in the Single-Digit Milliseconds

6. Deep Paging Did Not Show a Performance Cliff

7. Search `COUNT` Became the Dominant Cost

8. Zero-Result Short-Circuit Works — But Does Not Eliminate `COUNT`

9. Wildcard and Special Patterns Exposed a Reproducible Hotspot

10. Unicode and Non-ASCII Search Also Deserved Attention

11. Security Testing Revealed a Second Performance Question

12. Debounce and Cancellation During Rapid Typing

13. What the 50M Test Actually Proved

The dataset scaled to 50 million records

Page retrieval remained fast

Deep paging remained stable in the tested scenarios

`COUNT` became the dominant search cost

Zero-result page retrieval was short-circuited

Async search behavior remained active

Some search patterns were significantly more expensive

14. What the Test Did Not Prove

15. The Most Important Scaling Observation: 30M → 50M

16. Where the Bottleneck Moved

17. Classic Paging Is Not Automatically the Wrong Architecture

18. The Next Investigation

19. What the Stress Test Actually Found

Conclusion

Comments

Post a Comment

We Stress Tested 50 Million Records in C# WinForms. Here is What Broke

Handling 50 Million Records in C# WinForms: What the Stress Test Actually Found

1. Test Setup

2. The First Important Result: We Did Not Load 50 Million Rows into WinForms

3. Initial Load at 50 Million Records

4. 30 Million vs 50 Million Records

5. First-Page Fetch Stayed in the Single-Digit Milliseconds

6. Deep Paging Did Not Show a Performance Cliff

7. Search COUNT Became the Dominant Cost

8. Zero-Result Short-Circuit Works — But Does Not Eliminate COUNT

9. Wildcard and Special Patterns Exposed a Reproducible Hotspot

10. Unicode and Non-ASCII Search Also Deserved Attention

11. Security Testing Revealed a Second Performance Question

12. Debounce and Cancellation During Rapid Typing

13. What the 50M Test Actually Proved

The dataset scaled to 50 million records

Page retrieval remained fast

Deep paging remained stable in the tested scenarios

COUNT became the dominant search cost

Zero-result page retrieval was short-circuited

Async search behavior remained active

Some search patterns were significantly more expensive

14. What the Test Did Not Prove

15. The Most Important Scaling Observation: 30M → 50M

16. Where the Bottleneck Moved

17. Classic Paging Is Not Automatically the Wrong Architecture

18. The Next Investigation

19. What the Stress Test Actually Found

Conclusion

Comments

Post a Comment

7. Search `COUNT` Became the Dominant Cost

8. Zero-Result Short-Circuit Works — But Does Not Eliminate `COUNT`

`COUNT` became the dominant search cost