2006/3/14-16 [Computer/SW/Database] UID:42233 Activity:nil | 3/14 Hello Oracle experts. Is there a reason why .getProcedures takes
so long to execute? I've tried using different jdbc connectors
from different vendors and have the same results, so I think
it must be the DB hog backend. Why does it take so long?
try{
DatabaseMetaData dbmeta = con.getMetaData();
...
|
2003/3/12-13 [Computer/SW/Database] UID:27673 Activity:very high | 3/12 mySQL vs. postgreSQL: Thoughts? Likes? Dislikes? Horror stories?
Success stories? Thanks.
\_ I have found mySQL to be surprisingly good. I built a network
and system management product using mySQL for the db backend.
This system has been deployed in several dozen sites worldwide
with between 100-500 nodes managed per site. Most of the sites
...
|
2002/12/19-20 [Computer/SW/Database] UID:26856 Activity:high | 12/19 Does anyone have experience with oracle licensing? My company is
buying some oracle licenses. We have one production server, and
will get a 2 yr processor license on it. We also have a backup
database which will only be interacting with the main server. Can
we get the lower priced per-user license for the backup?
\_ We threatened to go with IBM or Sybase, and they dropped the
...
|
2002/12/5-6 [Computer/SW/Database] UID:26724 Activity:high | 12/5 Q for DBAs. How often do you examine your schema for new indexes
needed. Our lead programmer is giving me headaches with his "Well
it works on MSSQL," while our Postgres and Oracle development continues
to falter. I came up with a possible new index last night to solve
a customer's issue, and he got all up in arms with "DON'T QUESTION MY
SCHEMA!" Am I insane thinking that DB tuning should be ongoing?
...
|
2001/6/21-2002/2/6 [Computer/SW/Database] UID:21592 Activity:high 80%like:21634 66%like:22367 | 6/26 [ Kinney's drivel deleted. ]
\_ Does MySQL really do transactions, ACID, etc now?
anyone have a URL handy? --oj
\_ No, MySQL is not presently ACID compliant. That's why you
can corrupt MySQL databases if you throw enough traffic at
one. They just moved their transaction code into the stable
...
|
2001/6/19 [Computer/SW/Database] UID:21575 Activity:high | 6/19 database question
is there a way to have a unique ID span a database as opposed to only a
table... (so that no 2 tables will have records tied using the same
"autonumber")
\_ you could have a skinny table of just ID's and have all other tables
that you care about reference this column. I'm not sure if that
...
|
2000/1/5-7 [Computer/SW/OS/Windows, Computer/SW/Unix] UID:17163 Activity:low | 1.5 I read that there's an OBDC driver for Perl called win32::obdc .
However, I have vague knowledge on the subject after doing a
little research on it. My impression is that it's exclusively
used for the windows operating system; however, the FAQ on it alo
comes off as implying that it's available for Unix/Linux systems
as well. I know that OBDC has an interface to Oracle and a few
...
|
1999/8/16 [Computer/SW/Database] UID:16317 Activity:very high | 8/15 Been looking for a job on http://monster.com, http://dice.com, and link:acareer.com.
It seems that a majority of the high paid jobs are DBA, DB consulting,
DB app, Java+DB related. I don't understand. Database is boring. Why
the heck are they in such high demand?
\_ DB related is a specialist just like a Network Engineer,
Device Programmer or Graphics Programmer. If you're looking for
...
|
1998/7/8-9 [Computer/SW/OS/Linux, Computer/SW/OS/Windows] UID:14299 Activity:insanely high | 7/8 What happens if you do a set uid=0. Does that automatically
give your root access. (set gid=0, set user=root)
\_ You know, if you try logging in as "System Administrator"
without a password on some of those NT machines they'll let
you right in. Those are our security-minded sysadmins at
eecs instructional.
...
|
|