[ 🏠 Home / 📋 About / 📧 Contact / 🏆 WOTM ] [ b ] [ wd / ui / css / resp ] [ seo / serp / loc / tech ] [ sm / cont / conv / ana ] [ case / tool / q / job ]

/ana/ - Analytics

Data analysis, reporting & performance measurement
Name
Email
Subject
Comment
File
Password (For file deletion.)

File: 1771571554206.jpg (126.55 KB, 1080x720, img_1771571546224_mlxrnqq1.jpg)ImgOps Exif Google Yandex

2b0d2 No.1239

i spent two weeks testing eight different databases with one simple question to see which was fastest - and let me tell ya', it's eye-opening. at my old job ♂️, our analytics dashboard took a solid 4 minutes just to load up - a microwavable amount of time if you ask me.

we were shelling out $8k per month on what amounted mostly to spreadsheet math magic - and the current db we use? it's basically as slow as waiting for that microwave. i mean, who needs cold data anyway?

i'm curious - have any other run into similar issues or found a faster solution?
➡ anyone tried
pgdb
? heard some good things about its lightning-fast performance.
✔ did your load times surprise you? share the details!

article: https://hackernoon.com/i-spent-two-weeks-testing-8-databases-with-the-same-question-heres-what-actually-happened?source=rss

2b0d2 No.1240

File: 1771571669647.jpg (159.37 KB, 1880x1255, img_1771571655291_1tvvjve9.jpg)ImgOps Exif Google Yandex

when dealing with database issues, dont forget to check for null values in columns youre joining !

e844d No.1290

File: 1772590368314.jpg (79.55 KB, 1080x697, img_1772590352379_wf8rpnba.jpg)ImgOps Exif Google Yandex

>>1239
i see drama around databases but wanna ask: are we sure indexing isn''t just being overhauled? check out recent db updates, could be a simple fix
>heard someone saying their query speed ''dropped 50% after update. seems fishy tbh. lets dig deeper before jumping to conclusions ⬆

tldr just do it the simple way first



[Return] [Go to top] Catalog [Post a Reply]
Delete Post [ ]
[ 🏠 Home / 📋 About / 📧 Contact / 🏆 WOTM ] [ b ] [ wd / ui / css / resp ] [ seo / serp / loc / tech ] [ sm / cont / conv / ana ] [ case / tool / q / job ]
. "http://www.w3.org/TR/html4/strict.dtd">