Method print_results

benchmarks/benchmark_array_binary.py:273–327

Print benchmark results in a formatted table

(self)

        self.print_results()

    def print_results(self):
        """Print benchmark results in a formatted table"""
        print(f"\n{Fore.GREEN}📊 Array Binary Protocol Performance Results{Style.RESET_ALL}")
        print("=" * 80)

        # Group results by array size
        size_groups = {}
        for result in self.results:
            if result.array_size not in size_groups:
                size_groups[result.array_size] = []
            size_groups[result.array_size].append(result)

        for array_size in sorted(size_groups.keys()):
            print(f"\n{Fore.YELLOW}Array Size: {array_size} elements{Style.RESET_ALL}")

            table_data = []
            for result in size_groups[array_size]:
                overhead_color = ""
                if result.overhead_factor < 100:
                    overhead_color = Fore.GREEN
                elif result.overhead_factor < 500:
                    overhead_color = Fore.YELLOW
                else:
                    overhead_color = Fore.RED

                table_data.append([
                    result.operation,
                    f"{result.sqlite_time:.3f}",
                    f"{result.pgsqlite_time:.3f}",
                    f"{overhead_color}{result.overhead_factor:.1f}x{Style.RESET_ALL}"
                ])

            headers = ["Operation", "SQLite (ms)", "pgsqlite (ms)", "Overhead"]
            print(tabulate(table_data, headers=headers, tablefmt="grid"))

        # Summary
        print(f"\n{Fore.CYAN}📈 Summary{Style.RESET_ALL}")
        avg_overhead_by_op = {}
        for result in self.results:
            if result.operation not in avg_overhead_by_op:
                avg_overhead_by_op[result.operation] = []
            avg_overhead_by_op[result.operation].append(result.overhead_factor)

        summary_data = []
        for operation, overheads in avg_overhead_by_op.items():
            avg_overhead = statistics.mean(overheads)
            color = Fore.GREEN if avg_overhead < 100 else Fore.YELLOW if avg_overhead < 500 else Fore.RED
            summary_data.append([
                operation,
                f"{color}{avg_overhead:.1f}x{Style.RESET_ALL}"
            ])

        print(tabulate(summary_data, headers=["Operation", "Avg Overhead"], tablefmt="grid"))

        print(f"\n{Fore.GREEN}✅ Array binary protocol benchmarking complete!{Style.RESET_ALL}")

def main():
    import argparse