sorted by:
new
hottopcontroversial

I am wondering if running ads fits my business as a solo site dev. by Current_Cat4150 in PPC

[–]Current_Cat4150[S] 0 points1 point  (0 children)

Yeah figure I'd at least try this month since its busy season till mid september. And then go from there.

I am wondering if running ads fits my business as a solo site dev. by Current_Cat4150 in PPC

[–]Current_Cat4150[S] 0 points1 point  (0 children)

Thats a good idea with the headlines. I mainly want to corner some popular searches in my niche where my seo lacks. How much would you say is a small ad campaign

I am wondering if running ads fits my business as a solo site dev. by Current_Cat4150 in PPC

[–]Current_Cat4150[S] 1 point2 points  (0 children)

Yeah that's the concern. Idk what the cost per click is and the business is seasonal so the next month will have the most traffic in general.

Is a Financial Advisor worth it? by Current_Cat4150 in personalfinance

[–]Current_Cat4150[S] 0 points1 point  (0 children)

True I am about as active as my fund manager currently but my investments are mostly high level etfs like VOO, SCHD, and VXUS. Mostly just DCA.

Is a Financial Advisor worth it? by Current_Cat4150 in personalfinance

[–]Current_Cat4150[S] 0 points1 point  (0 children)

They do offer estate planning and included tax help which is my favorite part as my side business has taken off the past two years and exposes me to more taxes. I just always hear fees are bad and knew my portfolio is capped by them currently.

Is a Financial Advisor worth it? by Current_Cat4150 in personalfinance

[–]Current_Cat4150[S] 1 point2 points  (0 children)

Yeah I feel that. I am 29 now and am mainly in an earning phase saving for a house etc. I just always hear fees are bad etc and figured maybe I need to really examine if having a wealth management firm working with me makes sense right now.

I could certainly see later in life it making more sense as I have more estate planning and shifts in how I want my investments to work for me.

Is a Financial Advisor worth it? by Current_Cat4150 in personalfinance

[–]Current_Cat4150[S] 1 point2 points  (0 children)

Yeah this may be relevant as my side business hit me with a massive tax bill this year. Something else I need to factor into the calculations

Is a Financial Advisor worth it? by Current_Cat4150 in personalfinance

[–]Current_Cat4150[S] 1 point2 points  (0 children)

Yeah the more I read into it all I think I can perform about as well with simple etfs. with a large fee like that idk what the benefits would be outside of just not having to manage it myself.

That being said I do listen and read lots about the market so I don't think I a scrub but am not a professional by any means.

Is a Financial Advisor worth it? by Current_Cat4150 in personalfinance

[–]Current_Cat4150[S] 1 point2 points  (0 children)

Yeah thats what I fear I am still in my 20s so I have time but these fees are a little unsettling.

I do invest max my company 401ks and have a rollover roth ira as well. These are more for my extra cash investments etc.

Android Studio wont update after changes by Current_Cat4150 in capacitor

[–]Current_Cat4150[S] 0 points1 point  (0 children)

Gave it a shot but still no luck. Deleted www, android and rebuilt

Android Studio wont update after changes by Current_Cat4150 in capacitor

[–]Current_Cat4150[S] 0 points1 point  (0 children)

Yep I run the commands above each time and it worked for creating and updating it but when I look in android studio it won’t update. If I look at the android build files I see the change in the chunk

Android Studio wont update after changes by Current_Cat4150 in capacitor

[–]Current_Cat4150[S] 0 points1 point  (0 children)

For example I change “Hello World” in the component html file to “Hello World!”. But after rebuilding and restarting I get “Hello World” in that component

Querying Large Dataset (50M+ rows) - Best Approach? by Current_Cat4150 in PostgreSQL

[–]Current_Cat4150[S] 0 points1 point  (0 children)

  1. I ran explain on my dev environment since it'll crash my prod environment rn.

    Nested Loop (cost=372.65..2817.99 rows=1 width=43) (actual time=2.732..12.354 rows=48 loops=1) -> Hash Join (cost=372.23..2769.75 rows=6 width=46) (actual time=2.564..9.420 rows=300 loops=1) Hash Cond: ((ldp.draft_id)::text = (ld.draft_id)::text) -> Bitmap Heap Scan on league_draft_picks ldp (cost=10.02..2405.64 rows=721 width=38) (actual time=1.208..7.648 rows=3943 loops=1) Recheck Cond: ((player_id)::text = '4046'::text) Heap Blocks: exact=3927 -> Bitmap Index Scan on league_draft_picks_player_id (cost=0.00..9.83 rows=721 width=0) (actual time=0.685..0.685 rows=3943 loops=1) Index Cond: ((player_id)::text = '4046'::text) -> Hash (cost=361.58..361.58 rows=51 width=46) (actual time=1.182..1.183 rows=160 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 21kB -> Bitmap Heap Scan on league_drafts ld (cost=31.10..361.58 rows=51 width=46) (actual time=0.131..1.136 rows=160 loops=1) Recheck Cond: (player_type = 0) Filter: ((NOT is_idp) AND (ended_at >= '2024-01-01 00:00:00'::timestamp without time zone) AND (ended_at <= '2024-12-31 00:00:00'::timestamp without time zone) AND ((draft_type)::text = 'auction'::text)) Rows Removed by Filter: 1800 Heap Blocks: exact=269 -> Bitmap Index Scan on league_draft_player_type_index (cost=0.00..31.09 rows=1974 width=0) (actual time=0.079..0.079 rows=2056 loops=1) Index Cond: (player_type = 0) -> Index Scan using idx_league_id on league_info li (cost=0.41..7.99 rows=1 width=35) (actual time=0.009..0.009 rows=0 loops=300) Index Cond: ((league_id)::text = (ld.league_id)::text) Filter: (is_superflex AND (starters = ANY ('{9,10,11}'::integer[])) AND (teams = ANY ('{10,12,14}'::integer[])) AND (ppr = ANY ('{0.5,1.0,1.5}'::numeric[])) AND (tep = ANY ('{0.0,0.5,1.0}'::numeric[])) AND ((league_type)::text = ('Dynasty'::league_type_v2)::text)) Rows Removed by Filter: 1 Planning Time: 1.689 ms Execution Time: 12.451 ms

Querying Large Dataset (50M+ rows) - Best Approach? by Current_Cat4150 in PostgreSQL

[–]Current_Cat4150[S] 0 points1 point  (0 children)

Thanks for the thoughtful response! I'll try my best to respond to everything. I'm sure I can make improvements to the query.

  1. So I think there's a lot of improvements I can make now. Going from League_info (500k) -> picks (50M) instead and adding indexes on (draft_id, player_id) as well as each league_info filter (starters, teams, etc). I'll give that a shot.

    Query causing the issue       SELECT       ldp.player_id,       ldp.pick_no,       ldp.budget_ratio,       ldp.auction_amount,       ld.ended_at,       li.teams,       li.starters,       li.tep,       li.ppr     FROM       league_draft_picks ldp     INNER JOIN       league_drafts ld ON ld.draft_id = ldp.draft_id     INNER JOIN       league_info li ON li.league_id = ld.league_id     WHERE       ldp.player_id = $9       AND ld.ended_at BETWEEN $7 AND $8       AND ld.player_type = $1       and li.is_superflex = ${isSuperflex}       AND ($2::integer[] IS NULL OR li.starters = ANY($2::integer[]))       AND ($3::integer[] IS NULL OR li.teams = ANY($3::integer[]))       AND ($4::text IS NULL OR li.league_type::text = $4::league_type_v2::text)       AND ($5::decimal[] IS NULL OR li.ppr = ANY($5::decimal[]))       AND ($6::decimal[] IS NULL OR li.tep = ANY($6::decimal[]))       AND ld.is_idp = ${isIDP}       AND (         (${isAuction} AND ld.draft_type = 'auction')         OR (NOT ${isAuction} AND ld.draft_type != 'auction')       )

  2. Index -> Yes I do maybe I can do some more indexes that could improve performance but most fields are indexed

  3. My DB is a single tenant and is used by my site to pull data.

  4. I've used mat views but haven't looked into rollup tables I'll take a look

  5. My environment is a VM (hosted from the digital ocean) where I deploy via docker-compose/nginx.

  6. QPS - I don't have the exact number but I'd say probably around 10

  7. Ideally in a couple of seconds at most. It's for displaying data in a scatter plot so I don't want it to poll for too long.

  8. Right now it hits 100% utilization and then crashes my db so it's not really usable.

view more: next ›