comment on

I have several Windows machines running the same Perl (This is perl 5, version 24, subversion 2 (v5.24.2) built for MSWin32-x64-multi-thread, Activestate) for many years. Sqlite3 (3.36.0 2021-06-18 18:36:39) with a 4GB indexed database containing one table with about a million rows. On three PCs (Ryzen 3600 with 16GB RAM Win 10 Pro, Ryzen 2700X with 16GB RAM Win 10 Pro, Xeon 5660 with 12 GB RAM Win 7 Pro) I get 100,000 selects in about 10-15 seconds. On the 4th PC (AMD A8-7500 with 16GB RAM Win 7 Pro) it barely crawls. Maybe 100 selects in 10 minutes.

The code is identical all places. The DB is a separate copy on each machine. No errors or obvious clues about why it is sooo slow. Even on an older laptop it gets comparable performance.

I have examined the Windows logs and find nothing amiss. No device manager flags. Crystal Disk reads the system drive (SSD) at about 450MB/sec and the data drive (HD) at about 180MB/sec. procexp and procmon don't show anything obvious. taskmgr shows 25% CPU usage, and 13GB free memory. I have examined all the BIOS params and see none that need adjustment.

I have run out of ideas on how to troubleshoot this issue. Seems clear that the OS is throttling Perl, but I can't pinpoint it.

Thoughts? Ideas? Suggestions? Not critical, not commercial, but surprising given everything else Perl on Windows has been fast. I could move it to Debian, but would like to figure this one out.

Thanks.

In reply to Windows Perl with sqlite3 by miner7777

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


"be consistent"
	PerlMonks