Re: [plug] Large MySQL table

Yes because it's on the right side of the equality. there are other benefits to storing dates as integers -- it's how astronomers do it (Julian day). date arithmetic becomes trivial. there is no notion of "months" or "weeks" or "years" which are artificial constructs. you can use a float and als

Re: [plug] Sun Microsystems to Acquire MySQL for 1Billion

feature by feature comparison is useless unless you're using or going to use all those features that matters to you or to your app. we all know that the superiority of a product (based on whose standards?) alone is not enough to make it successful in the marketplace. it all depends on the size of t

Re: [plug] gui based apps

try http://www.openfiler.com/ - Looking for last minute shopping deals? Find them fast with Yahoo! Search._ Philippine Linux Users' Group (PLUG) Mailing List plug@lists.linux.org.ph (#PLUG @ irc.free.net.ph) R

Re: [plug] gui based apps

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 If you are going to use LDAP for the backend, then you can also use web based LDAP admin tools. Or better yet, use a ready made solution that already integrates LDAP and SAMBA for ease in administration. This one looks promising although I have net y

Re: [plug] gui based apps

Thanks for reminding webmin. I have read it before but never installed it. Looks like I'm gonna install it now. - Original Message From: Daniel Ortega <[EMAIL PROTECTED]> To: Philippine Linux Users' Group (PLUG) Technical Discussion List Sent: Friday, January 18, 2008 10:27:01 AM Su

Re: [plug] gui based apps

use webmin for system administration . read first. On Jan 18, 2008 9:59 AM, Nelson Serafica <[EMAIL PROTECTED]> wrote: > Anyone knows an application (a web-based or GUI like) tool where you can > add/delete user in Linux. I'll be deploying a file server (samba) and >

Re: [plug] gui based apps

try webmin, but be careful. On Jan 18, 2008 9:59 AM, Nelson Serafica <[EMAIL PROTECTED]> wrote: > Anyone knows an application (a web-based or GUI like) tool where you can > add/delete user in Linux. I'll be deploying a file server (samba) and > thinking if theirs an application that even a non-t

[plug] gui based apps

Anyone knows an application (a web-based or GUI like) tool where you can add/delete user in Linux. I'll be deploying a file server (samba) and thinking if theirs an application that even a non-techie guy can add/remove a user in a Linux machine via web-based. I'm avoiding them logging in to shel

Re: [plug] Large MySQL table

Aren't date fields stored as long integers? But then again, taking out the time part of a datestamp would go a long way in terms of storage and cpu use. I do have a question with regards to MySQL's query optimizer. In Roger's item #3, will MySQL compute the value of unix_timestamp() only once

Re: [plug] [SPAM] - Re: PLUG Digest, Vol 34, Issue 27 - Email found in subject

EnterpiseDB? > > Sun has postgreSQL in its list of products with support.. they will choose > what's going to be their default DB if a client doesn't want oracle… J can > anyone guess what SUN will choose? > > > > > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of wEnDeLL > Sen

Re: [plug] [SPAM] - Re: PLUG Digest, Vol 34, Issue 27 - Email found in subject

Sun has postgreSQL in its list of products with support.. they will choose what's going to be their default DB if a client doesn't want oracle... J can anyone guess what SUN will choose? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of wEnDeLL Sent: Thursday, January 17, 2008 9

Re: [plug] PLUG Digest, Vol 34, Issue 27

Just a disclaimer, it was mentioned on mysql[1] blog that Josh Berkus (PostgreSQL Lead) was a Sun employee together with Ian Murdock. So this acquisition could have an impact on this PostgreSQL vs. MySQL war. [1] - http://blogs.mysql.com/kaj/2008/01/16/sun-acquires-mysql/ > > ---

Re: [plug] Large MySQL table

Actually i had this same problem before too when i worked with date based alerts (scheduling)for mobile and the best advice i got was using timestamp date field since its supposed to be closer to int type datafield which was optimized with how mysql implemented indexing (search it out, i think it

Re: [plug] Large MySQL table

I think Tiger's dissertation on the subject said it all. =) I'm not sure what using an int datatype would buy you above and beyond just indexing datedue. I suppose using int *might* be slightly faster, but you would lose date functionality. And, from a purist's perspective, call a spade a spa

Re: [plug] Large MySQL table

Extreme solution: 1. change date field from datetime or timestamp to int type equivalent. Warning do not use alter table, data will be lost; make a script to re create the date data as int using unix_timestamp instead. 2. index the field. 3. rewrite sql as select id,datedue from table1 where dat

Re: [plug] Sun Microsystems to Acquire MySQL for 1Billion

and on the same day Oracle acquires BEA for 8x the money. :-) Oracle is doing it the other way around from Sun... OVM (Xen derivative) + OEL (RHEL derivative) => but not the hardware Contrary to popular belief, Sun doesn't make tons of money off Java. All the big vendors made one-time sourc