• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 19:07
CET 00:07
KST 08:07
  • 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
ByuL: The Forgotten Master of ZvT30Behind the Blue - Team Liquid History Book19Clem wins HomeStory Cup 289HomeStory Cup 28 - Info & Preview13Rongyi Cup S3 - Preview & Info8
Community News
2026 KongFu Cup Announcement3BGE Stara Zagora 2026 cancelled11Blizzard Classic Cup - Tastosis announced as captains15Weekly Cups (March 2-8): ByuN overcomes PvT block4GSL CK - New online series18
StarCraft 2
General
Blizzard Classic Cup - Tastosis announced as captains BGE Stara Zagora 2026 cancelled BGE Stara Zagora 2026 announced ByuL: The Forgotten Master of ZvT Terran AddOns placement
Tourneys
RSL Season 4 announced for March-April Sparkling Tuna Cup - Weekly Open Tournament 2026 KongFu Cup Announcement [GSL CK] Team Maru vs. Team herO StarCraft Evolution League (SC Evo Biweekly)
Strategy
Custom Maps
Publishing has been re-enabled! [Feb 24th 2026] Map Editor closed ?
External Content
The PondCast: SC2 News & Results Mutation # 516 Specter of Death Mutation # 515 Together Forever Mutation # 514 Ulnar New Year
Brood War
General
BSL 22 Map Contest — Submissions OPEN to March 10 ASL21 General Discussion BGH Auto Balance -> http://bghmmr.eu/ Are you ready for ASL 21? Hype VIDEO Gypsy to Korea
Tourneys
[Megathread] Daily Proleagues [BSL22] Open Qualifiers & Ladder Tours IPSL Spring 2026 is here! ASL Season 21 Qualifiers March 7-8
Strategy
Simple Questions, Simple Answers Soma's 9 hatch build from ASL Game 2 Fighting Spirit mining rates Zealot bombing is no longer popular?
Other Games
General Games
Path of Exile Stormgate/Frost Giant Megathread Nintendo Switch Thread PC Games Sales Thread No Man's Sky (PS4 and PC)
Dota 2
Official 'what is Dota anymore' discussion The Story of Wings Gaming
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
Five o'clock TL Mafia Mafia Game Mode Feedback/Ideas Vanilla Mini Mafia TL Mafia Community Thread
Community
General
Things Aren’t Peaceful in Palestine US Politics Mega-thread Mexico's Drug War Russo-Ukrainian War Thread NASA and the Private Sector
Fan Clubs
The IdrA Fan Club
Media & Entertainment
[Manga] One Piece Movie Discussion! [Req][Books] Good Fantasy/SciFi books
Sports
Formula 1 Discussion 2024 - 2026 Football Thread General nutrition recommendations Cricket [SPORT] TL MMA Pick'em Pool 2013
World Cup 2022
Tech Support
Laptop capable of using Photoshop Lightroom?
TL Community
The Automated Ban List
Blogs
Money Laundering In Video Ga…
TrAiDoS
Iranian anarchists: organize…
XenOsky
FS++
Kraekkling
Shocked by a laser…
Spydermine0240
Unintentional protectionism…
Uldridge
ASL S21 English Commentary…
namkraft
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1540 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
Zurich15363 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
12058 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
Canada17329 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
Poland17692 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
Spain18233 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
Poland4742 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
Canada17329 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
Hyrule19194 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
Poland17692 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
Poland17692 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
Poland17692 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
Poland17692 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
BSL
20:00
S22 - Ladder Tour #1
ZZZero.O89
LiquipediaDiscussion
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
elazer 360
PiGStarcraft156
Nathanias 101
JuggernautJason60
Ketroc 53
ROOTCatZ 53
Nina 31
StarCraft: Brood War
Sea 11073
ZZZero.O 89
Aegong 84
Backho 55
Dota 2
monkeys_forever326
canceldota22
LuMiX2
Super Smash Bros
hungrybox704
Heroes of the Storm
Khaldor304
Other Games
summit1g9885
FrodaN5593
Grubby4319
KnowMe407
crisheroes250
mouzStarbuck182
ArmadaUGS111
ViBE33
Organizations
Other Games
gamesdonequick2262
ComeBackTV 224
BasetradeTV50
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 17 non-featured ]
StarCraft 2
• musti20045 44
• HeavenSC 41
• LaughNgamezSOOP
• sooper7s
• AfreecaTV YouTube
• intothetv
• Migwel
• Kozan
• IndyKCrew
StarCraft: Brood War
• Azhi_Dahaki13
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• masondota21399
League of Legends
• Doublelift4524
• Scarra835
Other Games
• imaqtpie1303
Upcoming Events
Sparkling Tuna Cup
10h 53m
RSL Revival
10h 53m
ByuN vs SHIN
Maru vs Krystianer
WardiTV Team League
12h 53m
Patches Events
17h 53m
BSL
20h 53m
Replay Cast
1d
Replay Cast
1d 9h
Wardi Open
1d 12h
Monday Night Weeklies
1d 17h
OSC
2 days
[ Show More ]
WardiTV Team League
2 days
GSL
3 days
The PondCast
4 days
KCM Race Survival
4 days
WardiTV Team League
4 days
Replay Cast
5 days
KCM Race Survival
5 days
WardiTV Team League
5 days
Korean StarCraft League
6 days
uThermal 2v2 Circuit
6 days
BSL
6 days
Liquipedia Results

Completed

Proleague 2026-03-13
WardiTV Winter 2026
Underdog Cup #3

Ongoing

KCM Race Survival 2026 Season 1
Jeongseon Sooper Cup
BSL Season 22
RSL Revival: Season 4
Nations Cup 2026
ESL Pro League S23 Finals
ESL Pro League S23 Stage 1&2
PGL Cluj-Napoca 2026
IEM Kraków 2026
BLAST Bounty Winter 2026
BLAST Bounty Winter Qual

Upcoming

CSL Elite League 2026
ASL Season 21
Acropolis #4 - TS6
2026 Changsha Offline CUP
Acropolis #4
IPSL Spring 2026
CSLAN 4
Kung Fu Cup 2026 Grand Finals
HSC XXIX
uThermal 2v2 2026 Main Event
NationLESS Cup
Stake Ranked Episode 2
CS Asia Championships 2026
IEM Atlanta 2026
Asian Champions League 2026
PGL Astana 2026
BLAST Rivals Spring 2026
CCT Season 3 Global Finals
IEM Rio 2026
PGL Bucharest 2026
Stake Ranked Episode 1
BLAST Open Spring 2026
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 © 2026 TLnet. All Rights Reserved.