Tag Info

New answers tagged

0

Yes if ManipulatedEmployeeCheckIn[Id,FirstIn,FirstOut,SecondIn,SecondOut] contains redundant data which is also in EmployeeCheckIn[ Id,CheckIn,Type,Status] Yes in general NULL values should be avoided if possible This depends on your intention which seems to be contradicting your question. If you want to use EmployeeCheckIn[ Id,CheckIn,Type,Status] as a ...


-1

You need to learn how to use SQL. If you've learn any programming language now it is just the same but like other language it has it know commands and syntax. I learned SQL from http://www.w3schools.com/sql/ and connecting a project to SQL from https://msdn.microsoft.com. Manipulation of data can be done from SQL or code of the language you prefer.


1

You can: Use polling However, think about sending a request every 10 seconds. By using your suggested approach, you are keeping a long connection to the server, which is in turn keeping a busy process/thread. If this is used only by you, it's fine. If it's meant to be used by many users, it's a huge waste of resources, since the server will be busy doing ...


6

No, because you need at least basic IO capabilities to be able to serve up web content. Assuming you finesse that by using something else to put in front of your database server then, yes, technically that would be possible. It would just be horrible.


1

You raise Apache specifically, so I will discuss this in detail. Apache can be configured to log to a database, although it requires an external plugin to do so. Using such a plugin can make log analysis easier, but only if you intend to write your own log analysis software. Standard off-the-shelf log analysers assume your logs are in files, so you won't be ...


0

The concept of relational closure basically means that the result of any query is a relation which can be used in other queries as if it was a base table. This is an powerful concept because it makes queries composable. If SQL allowed you to write queries which output nested data structures, you would break this principle. A nested data structure is not a ...


-1

Complexity. Adding RDBMS will increase complexity of whole system astronomically. And ability to manage complexity is the main thing which distinguishes programmers from source code producers.


3

It is a matter of opinion. You might use postfix representation (à la RPN, or even some stack-oriented programming language), or some bytecode (specific to your expression language), or some s-expr syntax, if you want some more compact representation. JSON is probably a less compact textual representation but it is very widely used (and you've got many ...


1

I agree with Snowman and think you should do all the queries. Along with performance being negligible, you can gain some insights about the data changes that may benefit you and/or users: New Categories Removed Categories Categories that have changed. Someone is eventually going to ask what happened. "We got a new file," won't be enough.


2

Since you have the primary key of each record, I highly recommend using the approach of examining each record individually. Primary key lookups are extremely fast in any professional-grade database. Updating a record based on primary key has a very granular lock level and is fast. By inserting or updating rather than delete/insert, you maintain the ...


1

Yes, I have seen significant performance problems result from this sort of pattern. If you have branches in your sproc that result in making significantly different queries, under certain circumstances this can cause huge performance problems. SQL server will build an execution plan for a sproc when it needs to based on the values of the parameters passed ...


1

If you data requirement is the joined data (solution 2) then tailor your stored procedure for that data. Overly reusing a bunch of stored procedures that are select * from table is best case... cumbersome and worst case... high performance impact (think, pulling back more data than you need over the wire). Let the relational database management system do ...



Top 50 recent answers are included