Handling large queries/reports

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Handling large queries/reports

Postby josephlabarbara121 » Tue Dec 06, 2022 1:06 pm

Hi, designing some queries that will generate reports with several million records (the same hand will contribute mutiple rows within the dataset so these things can quickly get very large).

Is it possible to export results directly to a csv rather than manually exporting from the report viewing window (this would obviate the need to run the query many times in order to get past the current 100k records display limit that's been implemented)?

Alternatively is it possible to connect Excel to the database with a data connection and run the queries that way?

Is there a limit to how large a report (either based on row count, or csv size) can be generated by the current software?
josephlabarbara121
 
Posts: 15
Joined: Sat Nov 22, 2014 10:46 pm

Re: Handling large queries/reports

Postby Flag_Hippo » Wed Dec 07, 2022 4:56 am

A PokerTracker 4 report will show a max of 100,000 lines and that can only be exported to csv from the report itself. You may be able to connect to/query the database outside of PokerTracker 4 but that's beyond the scope of our support.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 25 guests

cron