2009/9/23-10/5 [Computer/SW/Database] UID:53392 Activity:nil | 9/23 I never took CS188, is there a good book that's an intro to formal
database theory, normalization, etc.? I've got experience with SQL
(MySQL & MSSQL), and understand tables, etc.
\_ You mean CS186?
\_ Oops, yah. 188 is AI or something?
\_ That's right.
...
|
2006/3/25-26 [Computer/SW/OS/FreeBSD] UID:42421 Activity:very high | 3/24 Wow! FreeBSD sure is stable! After seeing soda's amazing uptime
record, I sure want to go replace my Linux boxes with FreeBSD!
Please do not delete this, or burn down Linus' house because I have
blasphemed the holy FreeBSD. I'd love to see a genuine discussion with
examples from both sides comparing the stability of *modern* FreeBSD
and Linux machines running on x86 hardware. -dans
...
|
2006/2/16-17 [Computer/SW/Languages/Web] UID:41887 Activity:nil | 2/16 In PHP, If I loop $result=mysql_query("...SQL here..."); with
a lot of results, while reusing the variable
$result without ever using mysql_free_result($result),
would that make the memory space blow up? Like:
while (1) {
$result=mysql_query("...SQL HERE...");
...
|
2005/7/22-25 [Computer/SW/Database] UID:38784 Activity:nil | 7/22 I never took a formal DB theory class, excuse me for asking SQL
questions. When I create a table, I can choose PRIMARY KEY to be
based on a single or n-tuple column. When I do that, are indices
created automatically? Second question is, if the indices are
created for n-tuple, does that mean all the column have fast
index, or they are all based on previous columns? For example, if
...
|
2005/7/22-25 [Computer/SW/Database, Computer/SW/Languages/Misc] UID:38783 Activity:kinda low | 7/22 When I do SELECT AVG(col) FROM table, where col is integer, it takes
2 minutes and returns a float type. I'm suspecting part of the
problem is that it's doing floating point add? How do I make it
faster? Thanks.
\_ How many rows it is querying over?
\_ about ~2,000,000
...
|
2005/4/8-10 [Computer/SW/Database] UID:37118 Activity:moderate | 4/8 Anyone reccomend a good mysql programming tutorial that goes
beyond the basic select statements ? I would like to be able
to do a distinct on specific column and then do a count of all
the rows that have the corresponding values. thanks --ramberg
\_ select t.col, count(*) from tble t group by t.col;
\_ thanks. --ramberg
...
|
2004/11/22-23 [Computer/SW/OS/OsX] UID:35021 Activity:low | 11/22 What's a good database program for Mac OSX? I just found out they
don't make MS Access for macs. I did a quick search and found a
Filemaker. Can anyone recommend any others? Thanks.
\_ what's your need? FileMaker is fine (better than Access) for
personal/home use. -tom
\_ MySQL? as above, what do you need it for? I also like
...
|
2004/9/23-24 [Computer/SW/Database] UID:33727 Activity:kinda low | 9/23 SQL/MySQL question: If I create a DB with a field that's a
varchar(256), will I be wasting a lot of disk if the data is typically
only 5-10 chars long?
\_ No. It's not 1981 anymore.
\_ I just wanted to be sure I wasn't setting up something in a
horribly inefficient way.
...
|
|