This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import matplotlib.pyplot as plt | |
| import matplotlib.dates as mdates | |
| from datetime import datetime | |
| import pandas as pd | |
| task_data = { | |
| "Task Name": [ | |
| "Project Setup and Environment Configuration", "Design UI and Dashboard", | |
| "Develop Home Screen and Dashboard", "Implement Navigation Logic", | |
| "Develop Program Management Module", "Develop Area Management Module", |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| """ | |
| simulate_firebolt_pooling_varied.py | |
| This script performs the following steps: | |
| 1. Runs a dummy query (SELECT 1) to warm up the Firebolt engine. | |
| 2. Runs two simulations (each for 10 seconds): | |
| - WITHOUT connection pooling: A new connection is created for every query. | |
| - WITH connection pooling: A pre-warmed pool of connections is used. | |
| For each query, the script cycles through different severity filters (using numeric values) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import io | |
| import datetime | |
| import statistics | |
| from warcio.warcwriter import WARCWriter | |
| from warcio.statusandheaders import StatusAndHeaders | |
| from warcio.archiveiterator import ArchiveIterator | |
| from bs4 import BeautifulSoup | |
| from fastapi import FastAPI, Request | |
| from fastapi.responses import JSONResponse |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH | |
| /* Step 1 Leaf level – every City that appears in the hierarchy | |
| gets a row, if there is no matching entry in the sales | |
| table we treat its sales as 0. */ | |
| city_sales AS ( | |
| SELECT g.country , | |
| g.state , | |
| g.city , | |
| COALESCE(s.sales,0) AS sales | |
| FROM geo_hierarchy AS g |
OlderNewer