|
How does MySQL store timestamps internally? Is it an int, or a string or something else?
Started by Unkwntech on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I believe it uses a UNIX timestamp, which is an integer representing the number of seconds since the UNIX epoch: Jan 01 1970
32bit integer
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
From the MySQL Documentation :
TIMESTAMP: A four... .
|
|
Hi ,
Could someone please explain how does BULK INSERT internally work and why is it much faster than the normal INSERT operations ?
Regards, Shishir.
Answer Snippets (Read the full thread at stackoverflow):
I've not given it much.
Internally, it converts to an OLEDB recordset, then loads the table.
|
|
Basically, it is used to make an application instance singleton.
I wish to know, how it works internally and how does OS manage it ?
Started by Mac on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
This MSDN Article has some information about the underlying details... .
How the OS manages it is a consealed implementation detail, you can only use the mutex trough the OS-supplied functions (like ReleaseMutex() for example) .
It creates a system-wide object.
|
Ask your Facebook Friends
|
What happened internally (JVM) when System.gc() or finalize() method called?
Is this really collect garbage or reduce performance ?
Started by Thomman on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It is garbage....
The last question shouldn't have an "or" in it.
At this point when the objects are really being removed the finalize() is called on these objects before they vanish .
By invoking System.gc() the garbage collector is run (as the name says) .
|
|
What types of Technologies does Amazon.com use Internally? Databases? Programing languages? Web technology?
What technology is used to build ec2? s3? simpleDB?
Started by tyndall on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Amazon's internal infrastructure, from highscalability.com :
Linux Oracle C++ Perl Mason Java Jboss Servlets Amazon has simpleDB, at least for a programming API
And this is from a Job Description
Design, develop, implement, test, document and ....
|
|
Hi everyone...
I love to use LINQ on .net, but I wonder to know how does that works internally?
Does anyone know that?
Thks.
Started by rpf on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
But it ....
Also note that the runtime has no role in linq .
So when you write linq queries, they get executed using appropriate interfaces such as IQuerable .
Basically linq is a mixture of some language facilities (compiler) and some framework extensions .
|
|
We recently started hosting our public website internally. We are running dotnetnuke on windows server 2003 using IIS 6. Externally the site is super fast, but when you access the site internally it is considerably slower. When you access the site via...
Started by Josiah Pewterbaugh on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
If you're using the same namespace internally.
Firewall and then coming back into your network.
|
|
Hi all,
I wondering, how those "text-heavy" websites, like stackoverflow.com, news.yahoo.com, bbc.co.uk store their text internally?
Are those texts stored as text files? or stored in database?
How do they cope with the ever-increasing content?
Started by janetsmith on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
It can differ....
Tags might be in another table, but could also be separated by comma's in one table .
They are in a table together with columns like date, rating and tags .
When using mysql, they usually use text, mediumtext or longtext .
Usually in a database.
|
|
I am wondering if it is good practice to call public functions also internally.
By public functions I mean all methods/functions that you created explicitly to be called from other objects, modules, etc. For example methods that you would typically put...
Started by Rabarberski on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Don't wrap private methods in public.
There is no reason not to use public methods internally.
|
|
As part of my assignment I have to answer this question:
The Sales Department has decided to develop new software internally. They will thus need to manage the IT project formally. Briefly describe two suitable project management methodologies models ...
Started by Setareh on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
And they will ask for their projects to be done internally..
|