Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 2142
2 votes
Accepted

What should be architecture of multi client web application?

Let me start with: you miss 3: Mutliple databases each containing data for a number of clients - allows both scale out (important) as well as not having possibly hundreds of thousands of databases. B …
TomTom's user avatar
  • 4,658
9 votes
Accepted

Architectural Help Needed - MySQL or NoSQL for a table with 54 million records

Ah, what is the problem? a table with 54 million records A small table. Nice. I have one here with 8.5 billion rows. we have !300 inserts and !100 updates per minute Yeah. Small. I know. I …
TomTom's user avatar
  • 4,658
1 vote

Is SQL Server's FILETABLE suitable for storing large files (bigger than 10 GB)?

I would say no. You wrun into tons of Problems and you run into a lot of costs over time (licensing). I am all pro storing biary data in SQL when it makes sense, but 10g files would be way larger tha …
TomTom's user avatar
  • 4,658
1 vote
Accepted

Efficient schema to handle time interval queries on a huge table?

How they allow a quick query over different time intervals (minutes, hours, days, months, years...)? The trick is not to do it at runtime at all. If you think this is done by standard SQL "sele …
TomTom's user avatar
  • 4,658