(Advanced Search)
for
Home : Products : Others : Gossamer Community :

Products: Others: Gossamer Community: Re: [Paul] Datestamp storage in Community: Edit Log

Here is the list of edits for this post
Jan 29, 2003, 2:43 PM
webmaster33
Veteran (2312 posts)
Jan 29, 2003, 2:43 PM
Views: 5941
Re: [Paul] Datestamp storage in Community
Quote:
I'm not sure your research on the different database support for unix time is accurate either.
Paul, do it. You can research yourself. So go for it and search for a function what you think proves your statement. Here is my info source:
http://www.mysql.com/...rmation/crash-me.php
(BTW: that comparison was not done with the latest database versions, so may be possible that a feature was added in the meantime...)

If you decide to research yourself, don't forget you have to find unixtime to date function in all databases which don't support FROM_UNIXTIME() function directly, but may support through other function. So here are those databases, you should investigate for that function:
Oracle no | PostgreSQL no | MSSQL no

Quote:
just as a side point, using perl would slow down the process by an amount of time that is so small
No, once you have to do comparisons or (even worser) date conversion for all (which may be more thousands) records, it becomes really time consuming. The more record, slower working, just because we can't use LIKE.
However when you use LIKE in a query, will filter quickly the result you need (executing by database, which is several times faster than do this in Perl).
IMHO no more explain is needed.

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

Last edited by:

webmaster33: Jan 29, 2003, 2:50 PM

Edit Log: