• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 07:54
CET 13:54
KST 21:54
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
RSL Season 3 - Playoffs Preview0RSL Season 3 - RO16 Groups C & D Preview0RSL Season 3 - RO16 Groups A & B Preview2TL.net Map Contest #21: Winners12Intel X Team Liquid Seoul event: Showmatches and Meet the Pros10
Community News
RSL Season 3: RO16 results & RO8 bracket13Weekly Cups (Nov 10-16): Reynor, Solar lead Zerg surge1[TLMC] Fall/Winter 2025 Ladder Map Rotation14Weekly Cups (Nov 3-9): Clem Conquers in Canada4SC: Evo Complete - Ranked Ladder OPEN ALPHA12
StarCraft 2
General
RSL Season 3: RO16 results & RO8 bracket SC: Evo Complete - Ranked Ladder OPEN ALPHA RSL Season 3 - Playoffs Preview Mech is the composition that needs teleportation t GM / Master map hacker and general hacking and cheating thread
Tourneys
RSL Revival: Season 3 $5,000+ WardiTV 2025 Championship StarCraft Evolution League (SC Evo Biweekly) Constellation Cup - Main Event - Stellar Fest 2025 RSL Offline Finals Dates + Ticket Sales!
Strategy
Custom Maps
Map Editor closed ?
External Content
Mutation # 500 Fright night Mutation # 499 Chilling Adaptation Mutation # 498 Wheel of Misfortune|Cradle of Death Mutation # 497 Battle Haredened
Brood War
General
Data analysis on 70 million replays A cwal.gg Extension - Easily keep track of anyone soO on: FanTaSy's Potential Return to StarCraft [ASL20] Ask the mapmakers — Drop your questions FlaSh on: Biggest Problem With SnOw's Playstyle
Tourneys
[Megathread] Daily Proleagues Small VOD Thread 2.0 [BSL21] GosuLeague T1 Ro16 - Tue & Thu 22:00 CET [BSL21] RO16 Tie Breaker - Group B - Sun 21:00 CET
Strategy
Current Meta Game Theory for Starcraft How to stay on top of macro? PvZ map balance
Other Games
General Games
Clair Obscur - Expedition 33 Stormgate/Frost Giant Megathread EVE Corporation Path of Exile [Game] Osu!
Dota 2
Official 'what is Dota anymore' discussion
League of Legends
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Deck construction bug Heroes of StarCraft mini-set
TL Mafia
Mafia Game Mode Feedback/Ideas
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread The Games Industry And ATVI Things Aren’t Peaceful in Palestine About SC2SEA.COM
Fan Clubs
White-Ra Fan Club The herO Fan Club!
Media & Entertainment
[Manga] One Piece Movie Discussion! Anime Discussion Thread Korean Music Discussion
Sports
2024 - 2026 Football Thread Formula 1 Discussion NBA General Discussion MLB/Baseball 2023 TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
TL Community
The Automated Ban List
Blogs
The Health Impact of Joining…
TrAiDoS
Dyadica Evangelium — Chapt…
Hildegard
Saturation point
Uldridge
DnB/metal remix FFO Mick Go…
ImbaTosS
Customize Sidebar...

Website Feedback

Closed Threads



Active: 2224 users

The Big Programming Thread - Page 1018

Forum Index > General Forum
Post a Reply
Prev 1 1016 1017 1018 1019 1020 1032 Next
Thread Rules
1. This is not a "do my homework for me" thread. If you have specific questions, ask, but don't post an assignment or homework problem and expect an exact solution.
2. No recruiting for your cockamamie projects (you won't replace facebook with 3 dudes you found on the internet and $20)
3. If you can't articulate why a language is bad, don't start slinging shit about it. Just remember that nothing is worse than making CSS IE6 compatible.
4. Use [code] tags to format code blocks.
zatic
Profile Blog Joined September 2007
Zurich15355 Posts
May 27 2020 14:41 GMT
#20341
On May 27 2020 10:47 travis wrote:
That's actually more complicated than I need. The game won't have any spatial aspects, so no movement. Just conversation, so just text output and maybe some input.

Python is totally fine for that then. This sounds like a really simple flask or bottle app?
ModeratorI know Teamliquid is known as a massive building
Yurie
Profile Blog Joined August 2010
11932 Posts
Last Edited: 2020-05-27 16:00:05
May 27 2020 15:59 GMT
#20342
https://www.renpy.org/ An engine made for visual novels.

And since I fully missed the web part of the requirement and don't want to look stupid. https://renpy.beuc.net/
Deleted User 3420
Profile Blog Joined May 2003
24492 Posts
May 27 2020 16:09 GMT
#20343
Yurie you are a god

thanks everyone
JimmyJRaynor
Profile Blog Joined April 2010
Canada17026 Posts
Last Edited: 2020-05-31 13:17:28
May 31 2020 12:58 GMT
#20344
On May 07 2020 19:47 Manit0u wrote:
On another note, I'll have some fun in one side project now. Will be working with C code that was last touched in 1998.

how is it going so far?

I love these types of situations in the software development industry... that is, going through ancient code.

I've been doing the hermit-coder//"Bob Fitch" thing for several weeks now. A nursing org is replacing/overhauling a Contact Tracing Application made with CA-Clipper in the 1990s. The system's last big update occurred in 2005. It had major upgrades from 1995 to 2005. There is zero documentation. The last programmer who worked on the system is in his 60s. He experienced a major health catastrophe six months ago. I get what info I can from him. He charges the nursing org $200/hour so my time with him is very limited. There is one business analyst still working at the nursing organization that used this application. She has a vague recollection of how the system worked.

My best source of info : Turn on the Tracer and step through the code one line at a time.

Hermit Coder War Stories are the best...

Bob Fitch rescued the Starcraft 1 project by locking himself in a room for several weeks/months and making the SC1 engine.

I've been doing a similar thing for the last two months. I've been tasked with jamming together a project in a very unreasonably short timeline.

I've done the hermit coder thing several times in my career. It has built me some major street cred with project managers and CIOs. Some people can't handle it for whatever reason. I'm an only child and grew up only with my mom. As a child and teenager I had the whole house to myself a lot. So doing the hermit coder thing is right in my comfort zone.

I hear people whine, bitch, moan and complain about "crunch time". Personally, I love it. I'm having a blast.

On May 07 2020 03:27 Manit0u wrote:
Unfortunately this is not something that's easily achievable yourself. Only after spending years doing similar projects over and over, maintaining them, revisiting them and changing them do you really begin to easily recognize all those common patterns and such. Sure, there are books on enterprise patterns etc. but you can memorize them and still not see the patterns in the actual code (and there are other patterns than just coding ones). Another thing with experience and doing the same stuff over and over is that you can see the pitfalls in advance. You know that you need to do extra bit of coding to prevent code locks, running out of memory, problems with garbage collection in certain situations and you know that before the first line of code is written which saves you a lot of time down the line (when you have to fix code that's been in production for a while and only then the problems start to show up).


i find this an interesting theme brought up in Aldous Huxley's "Brave New World". One can memorize and one can even parrot something and still never actually understand.


“The Nile is the longest river in Africa and the second in length of all the rivers of the globe. Although falling short of the length of the Mississippi-Missouri, the Nile is at the head of all rivers as regards the length of its basin, which extends through 35 degrees of latitude …”

At breakfast the next morning, “Tommy,” some one says, “do you know which is the longest river in Africa?” A shaking of the head. “But don’t you remember something that begins: The Nile is the …”

“The – Nile – is – the – longest – river – in – Africa – and – the – second -in – length – of – all – the – rivers – of – the – globe …” The words come rushing out. “Although – falling – short – of …”

“Well now, which is the longest river in Africa?”

The eyes are blank. “I don’t know.”

“But the Nile, Tommy.”

“The – Nile – is – the – longest – river – in – Africa – and – second …”

“Then which river is the longest, Tommy?”

Tommy burst into tears. “I don’t know,” he howls.)


later in the same chapter...
That howl, the Director made it plain, discouraged the earliest investigators. The experiments were abandoned. No further attempt was made to teach children the length of the Nile in their sleep. Quite rightly. You can’t learn a science unless you know what it’s all about.


https://opentextbc.ca/englishliterature/chapter/brave-new-world-chapter-two/
Ray Kassar To David Crane : "you're no more important to Atari than the factory workers assembling the cartridges"
Manit0u
Profile Blog Joined August 2004
Poland17450 Posts
June 01 2020 16:18 GMT
#20345
On May 31 2020 21:58 JimmyJRaynor wrote:
Show nested quote +
On May 07 2020 19:47 Manit0u wrote:
On another note, I'll have some fun in one side project now. Will be working with C code that was last touched in 1998.

how is it going so far?

I love these types of situations in the software development industry... that is, going through ancient code.


It's going slow. I'm preoccupied with some other stuff so that's mostly a side-project for me. In any case, I've created new structure for the directory with subdirectories and such (previously it was just a mess with everything being in a single directory) and started cleaning it up a bit by removing unnecessary stuff that clogs it up (big chunks of the code were poached from somewhere else and half of it is unused). Once that's done I'll start the real refactoring.
Time is precious. Waste it wisely.
Chocolate
Profile Blog Joined December 2010
United States2350 Posts
June 06 2020 03:07 GMT
#20346
On May 31 2020 21:58 JimmyJRaynor wrote:
Show nested quote +
On May 07 2020 19:47 Manit0u wrote:
On another note, I'll have some fun in one side project now. Will be working with C code that was last touched in 1998.

how is it going so far?

I love these types of situations in the software development industry... that is, going through ancient code.

I've been doing the hermit-coder//"Bob Fitch" thing for several weeks now. A nursing org is replacing/overhauling a Contact Tracing Application made with CA-Clipper in the 1990s. The system's last big update occurred in 2005. It had major upgrades from 1995 to 2005. There is zero documentation. The last programmer who worked on the system is in his 60s. He experienced a major health catastrophe six months ago. I get what info I can from him. He charges the nursing org $200/hour so my time with him is very limited. There is one business analyst still working at the nursing organization that used this application. She has a vague recollection of how the system worked.

My best source of info : Turn on the Tracer and step through the code one line at a time.

Hermit Coder War Stories are the best...

Bob Fitch rescued the Starcraft 1 project by locking himself in a room for several weeks/months and making the SC1 engine.

I've been doing a similar thing for the last two months. I've been tasked with jamming together a project in a very unreasonably short timeline.

I've done the hermit coder thing several times in my career. It has built me some major street cred with project managers and CIOs. Some people can't handle it for whatever reason. I'm an only child and grew up only with my mom. As a child and teenager I had the whole house to myself a lot. So doing the hermit coder thing is right in my comfort zone.

I hear people whine, bitch, moan and complain about "crunch time". Personally, I love it. I'm having a blast.

Show nested quote +
On May 07 2020 03:27 Manit0u wrote:
Unfortunately this is not something that's easily achievable yourself. Only after spending years doing similar projects over and over, maintaining them, revisiting them and changing them do you really begin to easily recognize all those common patterns and such. Sure, there are books on enterprise patterns etc. but you can memorize them and still not see the patterns in the actual code (and there are other patterns than just coding ones). Another thing with experience and doing the same stuff over and over is that you can see the pitfalls in advance. You know that you need to do extra bit of coding to prevent code locks, running out of memory, problems with garbage collection in certain situations and you know that before the first line of code is written which saves you a lot of time down the line (when you have to fix code that's been in production for a while and only then the problems start to show up).


i find this an interesting theme brought up in Aldous Huxley's "Brave New World". One can memorize and one can even parrot something and still never actually understand.

Show nested quote +

“The Nile is the longest river in Africa and the second in length of all the rivers of the globe. Although falling short of the length of the Mississippi-Missouri, the Nile is at the head of all rivers as regards the length of its basin, which extends through 35 degrees of latitude …”

At breakfast the next morning, “Tommy,” some one says, “do you know which is the longest river in Africa?” A shaking of the head. “But don’t you remember something that begins: The Nile is the …”

“The – Nile – is – the – longest – river – in – Africa – and – the – second -in – length – of – all – the – rivers – of – the – globe …” The words come rushing out. “Although – falling – short – of …”

“Well now, which is the longest river in Africa?”

The eyes are blank. “I don’t know.”

“But the Nile, Tommy.”

“The – Nile – is – the – longest – river – in – Africa – and – second …”

“Then which river is the longest, Tommy?”

Tommy burst into tears. “I don’t know,” he howls.)


later in the same chapter...
Show nested quote +
That howl, the Director made it plain, discouraged the earliest investigators. The experiments were abandoned. No further attempt was made to teach children the length of the Nile in their sleep. Quite rightly. You can’t learn a science unless you know what it’s all about.


https://opentextbc.ca/englishliterature/chapter/brave-new-world-chapter-two/

Great post.

Crunch time is my favorite time too. I actually love hitting those weeklong streaks of huge productivity (and usually knowledge/skill) gains and making heads turn. However in a team setting it can work against you if peers get jealous/angry at you for setting higher standards which are admittedly very unsustainable or if managers decide they can squeeze more work out of the team by creating false urgency.

The biggest issue with patterns is as you said, thinking that more applied patterns to code = better code because patterns are in books about writing software. Patterns when misapplied can also make things needlessly brittle or verbose and hard to understand. Even inheritance can be an antipattern.

Lately I've been working a lot with an old-ish piece of cloud infrastructure written in C++ which over time morphed into an uber-dependency ball of mud surrounding a white-hot request path. It has a pattern of applying behavior to the inbound request and outbound response *everywhere*. If you want to make a change, you better get ready to read 100k lines of code, because you'll have no way of understanding how the change will actually impact a request. Sure, there are tests, but only the Old Ones understood the design well enough to test changes coherently (and even so most of the tests are just trivially verifying a boring implementation detail or extraneous behavior - many of which never see the light of day in real use cases, but which are kept around Just In Case), and there's no way to spin up anything remotely resembling an actual prod environment, because it has so many other infrastructural dependencies. I've learned so much of what not to do, or how something which sounds like a good design can degenerate over a decade/dozens of engineers, that it's been a great learning experience.

Biggest takeaway: if you're doing something impressive, it doesn't matter how shitty or unmaintainable your code is as long as it gets you promoted into something that doesn't require you to maintain it. My VP is one of the original authors
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
June 10 2020 01:49 GMT
#20347
I have a DB instance on AWS RDS which is giving a crazy amount of data in replies. I want to see what the requests and replies are to see why the amount of data is so high. I've found this pretty difficult to do.

Does anyone know of a way to monitor the incoming/outgoing HTTP requests/responses?

Currently I'm trying VPC Traffic Mirroring but it seems relatively involved. Is there a better/easier option?
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
Acrofales
Profile Joined August 2010
Spain18131 Posts
June 10 2020 06:26 GMT
#20348
On June 10 2020 10:49 WarSame wrote:
I have a DB instance on AWS RDS which is giving a crazy amount of data in replies. I want to see what the requests and replies are to see why the amount of data is so high. I've found this pretty difficult to do.

Does anyone know of a way to monitor the incoming/outgoing HTTP requests/responses?

Currently I'm trying VPC Traffic Mirroring but it seems relatively involved. Is there a better/easier option?

I'm not all that familiar with all the AWS services, but there's cloudwatch that you can use to monitor most of them. There's also the log files themselves. And imho your best option is to find one of the clients that is causing the data, and look at what they're doing. Imho looking at what the server is doing or what the client is doing is almost always easier than trying to figure it out from packages on the network. Unless it's actually a network issue.
Silvanel
Profile Blog Joined March 2003
Poland4733 Posts
June 10 2020 08:30 GMT
#20349
Expanded logging is imho the way to go, personally i find it much easier than analysing traffic itself.
Pathetic Greta hater.
JimmyJRaynor
Profile Blog Joined April 2010
Canada17026 Posts
Last Edited: 2020-06-10 08:52:02
June 10 2020 08:40 GMT
#20350
On June 10 2020 10:49 WarSame wrote:
I have a DB instance on AWS RDS which is giving a crazy amount of data in replies. I want to see what the requests and replies are to see why the amount of data is so high. I've found this pretty difficult to do.

Does anyone know of a way to monitor the incoming/outgoing HTTP requests/responses?

Currently I'm trying VPC Traffic Mirroring but it seems relatively involved. Is there a better/easier option?

i use West Wind Web Surge.
https://websurge.west-wind.com/

On June 06 2020 12:07 Chocolate wrote:
The biggest issue with patterns is as you said, thinking that more applied patterns to code = better code because patterns are in books about writing software. Patterns when misapplied can also make things needlessly brittle or verbose and hard to understand. Even inheritance can be an antipattern.

lol, yep. when i first wrapped my head around how inheritance worked i created an inheritance anti-pattern. i was just trying to fully understand it so i shoe-horned it in a place it did not belong. For me , it was a solution.. looking for a problem.

regarding anti-patterns ... this book is old, however, imo, it is a timeless classic. you can probably find it for free someplace due to its advanced age. it is fucking hilarious.

https://www.amazon.ca/AntiPatterns-Refactoring-Software-Architectures-Projects/dp/0471197130
Ray Kassar To David Crane : "you're no more important to Atari than the factory workers assembling the cartridges"
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
June 10 2020 14:01 GMT
#20351
On June 10 2020 15:26 Acrofales wrote:
Show nested quote +
On June 10 2020 10:49 WarSame wrote:
I have a DB instance on AWS RDS which is giving a crazy amount of data in replies. I want to see what the requests and replies are to see why the amount of data is so high. I've found this pretty difficult to do.

Does anyone know of a way to monitor the incoming/outgoing HTTP requests/responses?

Currently I'm trying VPC Traffic Mirroring but it seems relatively involved. Is there a better/easier option?

I'm not all that familiar with all the AWS services, but there's cloudwatch that you can use to monitor most of them. There's also the log files themselves. And imho your best option is to find one of the clients that is causing the data, and look at what they're doing. Imho looking at what the server is doing or what the client is doing is almost always easier than trying to figure it out from packages on the network. Unless it's actually a network issue.

Cloudwatch I believe is only used for metrics. It's what I used to tell me why we might be getting some latency for DB access. It showed me we have 2 GB/5 minutes with only a few users online.

I was thinking that too but haven't been able to get DB access as easily as I hoped. I was reading up on it and most replies said that DBs generally have most of their queries saved, which would be helpful, but wouldn't be proof-positive that they are why the replies are so large. I don't know their DB and don't have great connectivity to their team so I was hoping to black box the DB, but I've requested access now. I tried VPC mirroring but after spending ~2 hours reading up on it and setting it up I was just not getting any traffic to my monitoring EC2 instance, so that was frustrating.
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
tofucake
Profile Blog Joined October 2009
Hyrule19159 Posts
Last Edited: 2020-06-10 15:37:28
June 10 2020 15:35 GMT
#20352
DB logs have been not so helpful for me, but I'm running Redshift, not RDS. I've had queries running that don't show up in the Running Queries Log.

Try reading this for whatever DB they have running: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.html
it might help...

Otherwise, you'll probably need to do in-DB checks. Postgres has stl_* tables, Maria/MySQL have similar tables, and MSSQL has the same sort of thing but I forget what it's called.

If you have AWS console access to the instance there's a tab for query logs in the cluster panel somewhere.
Liquipediaasante sana squash banana
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
June 11 2020 03:23 GMT
#20353
The issue is we were interested in which queries were causing such long replies, so just checking the queries wouldn't work(or would, but you'd have to inspect and reason about each individually). I've done traffic mirroring and put the PCAP into Wireshark. I then analyzed the traffic and found that we had a few reasons for so much traffic.

1. Tons of queries per conversation - ~75 queries to display one page to user. This is not a SPA and is stateless so the whole state must be reloaded every time
2. Queries with extra fields - a number of queries are using select * for tables with ~90 fields. Each field is ~100 bytes, leading to 10 KB replies. When you have 75 replies that's quite a lot.

The solutions I've proposed:

1. reduce the number of queries used, use a SPA or something else to reduce it. Long term strategy.
2. don't select *, select the fields you need

This should help reduce the traffic we saw from the DB.

I was also asked to investigate the latency to the DB. I noticed that the conversation took 0.3s for a particular example.

A large part of this was TCP/IP wait/response times. Previously the DB and all servers were on the same machine. They are now on different machines but that requires TCP/IP. Each query runs in serial, so the TCP/IP overhead is added up 75 times.

I have suggested to run these queries in parallel if possible to only suffer the TCP/IP overhead added to the longest query.

Feedback welcome.
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
Manit0u
Profile Blog Joined August 2004
Poland17450 Posts
Last Edited: 2020-06-11 19:59:21
June 11 2020 19:58 GMT
#20354
On June 11 2020 12:23 WarSame wrote:
The issue is we were interested in which queries were causing such long replies, so just checking the queries wouldn't work(or would, but you'd have to inspect and reason about each individually). I've done traffic mirroring and put the PCAP into Wireshark. I then analyzed the traffic and found that we had a few reasons for so much traffic.

1. Tons of queries per conversation - ~75 queries to display one page to user. This is not a SPA and is stateless so the whole state must be reloaded every time
2. Queries with extra fields - a number of queries are using select * for tables with ~90 fields. Each field is ~100 bytes, leading to 10 KB replies. When you have 75 replies that's quite a lot.

The solutions I've proposed:

1. reduce the number of queries used, use a SPA or something else to reduce it. Long term strategy.
2. don't select *, select the fields you need

This should help reduce the traffic we saw from the DB.

I was also asked to investigate the latency to the DB. I noticed that the conversation took 0.3s for a particular example.

A large part of this was TCP/IP wait/response times. Previously the DB and all servers were on the same machine. They are now on different machines but that requires TCP/IP. Each query runs in serial, so the TCP/IP overhead is added up 75 times.

I have suggested to run these queries in parallel if possible to only suffer the TCP/IP overhead added to the longest query.

Feedback welcome.


Defninitely get rid of stars in your selects. You might also think about adding a cache layer if you fetch the same data often, this would let you avoid the DB queries and round trips.

Another thing that comes to mind is also reducing the number of queries. Maybe you can fetch more data with a single query instead of 5? Also, if you have data overlap between the queries you could look into that.
Time is precious. Waste it wisely.
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
June 11 2020 23:32 GMT
#20355
They do have a redis cache set up already. Thanks for the great advice! An in-memory cache will be really useful for their more common queries, which should be easily cachable.

They know(and told me when I was starting) that they need to reduce the number of queries but it's a bit of a process. They have a small team so everything takes a while just to work through. I don't think most of their queries are combinable. I think going with SPA might be their best bet for reducing traffic. I know that's on their radar, just going to take a while.
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
Manit0u
Profile Blog Joined August 2004
Poland17450 Posts
Last Edited: 2020-06-12 21:40:48
June 12 2020 18:05 GMT
#20356
Redis cache is nice but to get some real gains you'd need to look into memcached and stuff like that. Reducing the number of queries is doable even with a small team. I work in a team of 7 people who are responsible for the mission critical elements of multi-million industry and we somehow manage to introduce new features along with doing optimizations and improvements to old stuff.

It all depends on how you approach it, at one point we had ~20% of our sprints reserved for stuff like technical debt reduction, code cleanup etc. Sometimes we even did 100% sprint just for that when we had some more leeway (back-end was ahead of front-end and we had to wait for them to catch up).

Every company handles this differently but if they could do small incremental changes where each one would help even a little bit with not too much effort I think they should go for it. Like, one developer (not entire team) spending one day of a sprint on removing 1 query from the 75 should not be too disruptive and it would eventually lead to more improvements.
Time is precious. Waste it wisely.
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
June 14 2020 16:26 GMT
#20357
Yeah, I think for them the real answer is to pivot towards more an SPA approach, because that will naturally split up and group their queries, preventing the serial issue. The asterisk issue I think they're willing to spend a significant amount of a sprint or 2 towards which should be all they need.

You need to keep in mind that they are a company with a small team, not just one team of a larger company. They have 5 people, of which only 2 are heavily technical. Your team, I'd imagine is 7/7 tech people, or maybe with one solution owner.
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
Manit0u
Profile Blog Joined August 2004
Poland17450 Posts
Last Edited: 2020-06-14 19:13:05
June 14 2020 19:05 GMT
#20358
On June 15 2020 01:26 WarSame wrote:
Yeah, I think for them the real answer is to pivot towards more an SPA approach, because that will naturally split up and group their queries, preventing the serial issue. The asterisk issue I think they're willing to spend a significant amount of a sprint or 2 towards which should be all they need.

You need to keep in mind that they are a company with a small team, not just one team of a larger company. They have 5 people, of which only 2 are heavily technical. Your team, I'd imagine is 7/7 tech people, or maybe with one solution owner.


7/7 tech. 2 front-end guys and 5 back-end people (including team leader).

Another tidbit that could help them with removing asterisks and prepare the queries better for the SPA would be creating the views where you have the data aggregated and you query the view instead of actual tables. They don't have to be materialized views, just planning out and creating the views themselves forces you to get rid of asterisks and allows you to cull the columns you don't need.
Time is precious. Waste it wisely.
Manit0u
Profile Blog Joined August 2004
Poland17450 Posts
June 15 2020 12:23 GMT
#20359
https://www.zdnet.com/article/github-to-replace-master-with-alternative-term-to-avoid-slavery-references/

This is seriously getting ridiculous. What's next? All the DBs with master/slave replicas and all the OSs with multiple HDDs?
Time is precious. Waste it wisely.
Nesserev
Profile Blog Joined January 2011
Belgium2760 Posts
Last Edited: 2020-06-15 13:43:39
June 15 2020 13:40 GMT
#20360
--- Nuked ---
Prev 1 1016 1017 1018 1019 1020 1032 Next
Please log in or register to reply.
Live Events Refresh
SC Evo League
12:30
#16
SteadfastSC5
LiquipediaDiscussion
WardiTV Korean Royale
12:00
Group B
WardiTV1110
LiquipediaDiscussion
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
Lowko168
Rex 161
SortOf 143
MindelVK 30
trigger 20
SteadfastSC 5
StarCraft: Brood War
Britney 49484
Rain 2954
Larva 629
firebathero 475
PianO 459
Mini 384
Last 284
Killer 213
Rush 139
sorry 80
[ Show more ]
Aegong 68
Backho 42
zelot 35
soO 32
Movie 28
ToSsGirL 26
HiyA 25
yabsab 25
Oya187 21
Hm[arnc] 14
Purpose 13
ivOry 7
Terrorterran 7
Icarus 7
Dota 2
Gorgc3983
Dendi782
XcaliburYe321
League of Legends
JimRising 352
Reynor107
Counter-Strike
ScreaM1517
zeus937
oskar124
edward29
Super Smash Bros
Chillindude12
Heroes of the Storm
Khaldor214
Other Games
B2W.Neo1609
crisheroes370
Fuzer 101
Trikslyr29
Organizations
Dota 2
PGL Dota 2 - Main Stream25264
StarCraft 2
ComeBackTV 854
Other Games
gamesdonequick549
StarCraft: Brood War
lovetv 5
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 12 non-featured ]
StarCraft 2
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• lizZardDota240
League of Legends
• Stunt848
Upcoming Events
IPSL
4h 6m
Julia vs Artosis
JDConan vs DragOn
OSC
4h 6m
BSL 21
7h 6m
TerrOr vs Aeternum
HBO vs Kyrie
RSL Revival
18h 36m
Wardi Open
1d 1h
IPSL
1d 7h
StRyKeR vs OldBoy
Sziky vs Tarson
BSL 21
1d 7h
StRyKeR vs Artosis
OyAji vs KameZerg
OSC
1d 10h
OSC
1d 20h
Monday Night Weeklies
2 days
[ Show More ]
OSC
2 days
Wardi Open
2 days
Replay Cast
3 days
Wardi Open
3 days
Tenacious Turtle Tussle
4 days
The PondCast
4 days
Replay Cast
5 days
LAN Event
6 days
Replay Cast
6 days
Replay Cast
6 days
Liquipedia Results

Completed

Proleague 2025-11-16
Stellar Fest: Constellation Cup
Eternal Conflict S1

Ongoing

C-Race Season 1
IPSL Winter 2025-26
KCM Race Survival 2025 Season 4
SOOP Univ League 2025
YSL S2
BSL Season 21
CSCL: Masked Kings S3
SLON Tour Season 2
RSL Revival: Season 3
META Madness #9
BLAST Rivals Fall 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
Thunderpick World Champ.
CS Asia Championships 2025
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2

Upcoming

BSL 21 Non-Korean Championship
Acropolis #4
IPSL Spring 2026
HSC XXVIII
RSL Offline Finals
WardiTV 2025
IEM Kraków 2026
BLAST Bounty Winter 2026
BLAST Bounty Winter 2026: Closed Qualifier
eXTREMESLAND 2025
ESL Impact League Season 8
SL Budapest Major 2025
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Disclosure: This page contains affiliate marketing links that support TLnet.

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2025 TLnet. All Rights Reserved.