14
gitpush
7y

Started to learn nodejs REST, with mongodb, either the service is too light (still only has login) or mongodb is too fast, I've never seen that speed in fetching a single user with 6 properties in its json response, it takes 15ms on my laptop when a dot net core service + MySQL takes at least 70ms

Comments
  • 3
    Yep, those speeds are normal. If you're one of those folks who over-optimize, you can get slightly better response times with GraphQL + Express.
  • 3
    @saintograph adding it to my to do list 😀
  • 1
    @notcool are string indexes ok? Haven't checked yet but in an SQL db it is better to not add indexes for varchar cols
  • 0
    @gitpush What is wrong with indexes on varchar cols? They speed up text search queries.
  • 1
    @arraysstartat1 for large text they could be a problem, I once took and Oracle DBA course and the lecturer emphasized on not doing it as it reduces db performance
  • 0
    @notcool interesting, I'll check it out thanks man. Though my point was not to index on large strings and multiple strings, u mean username and phone number are considered short but address, or info are large enough
Add Comment