ms 85.178 ms 87.600 ms
Thanks,
Brad Teale
Universal Weather and Aviation, Inc.
mailto:[EMAIL PROTECTED]
-Original Message-
From: Peter Burden [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 7:35 AM
To: Lehman, Jason (Registrar's Office)
Cc: [EMAIL PROTECTED]; [EMAIL
There is a C++ package called OTL (http://otl.sourceforge.net/home.htm).
It supports both MySQL through MyODBC, and Oracle. It works great with
Oracle applications, but we have not used it with MySQL.
Thanks,
Brad Teale
Universal Weather and Aviation, Inc.
mailto:[EMAIL PROTECTED]
713-944-1440
It has been a while since I have looked, but I believe the National
Genealogical Society has a data model for family tree software. The
following links are to the NGS and GEDCOM is the file format standard.
I think it should be an easy conversion to a database structure. If you
do something
There is a C++ package called OTL (http://otl.sourceforge.net/home.htm).
It supports both MySQL through MyODBC, and Oracle. It works great with
Oracle applications, but we have not used it with MySQL.
Thanks,
Brad Teale
Universal Weather and Aviation, Inc.
mailto:[EMAIL PROTECTED]
713-944-1440
Brendan,
We have used ext2, ext3, and reiser for testing purposes, and we have
found ext3 to be terribly slow on file read/write operations. If you need
a journaling file system, I would go with reiser, otherwise ext2 will be
blazingly fast.
The other thing I would do is move your DB to
Thank you very much Paul. The order by NULL clause sped the query up
from 1.5 minutes to 10 seconds! This is what we were looking for.
Thanks,
Brad
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 9:59 PM
To: Brad Teale; '[EMAIL PROTECTED
Hello,
The problem:
I have the following query with is taking upwards of 2 minutes to complete
and we need it faster, prefer less than 30 seconds (don't laugh):
select modelhr, avg(f.temp-b.temp), avg(abs(f.temp-b.temp)),
stddev(f.temp-b.temp), stddev(abs(f.temp-b.temp)), count(f.temp-b.temp)
Hi All,
I asked earlier about a query being slow, possibly due to MySQL 'Using
temporary; Using filesort' when processing the query. I have done some
testing, and it appears that no matter what data set is used, MySQL always
performs a select with a 'grant by' clause using the temporary and
We are warehousing real-time data. The data is received at up to T1 speeds,
and is broken up and stored into the database in approximately 25 different
tables. Currently MySQL is doing terrific, we are using MyISAM tables and
are storing 24 hours worth of data but we don't have any users and we
much of a performance hit would we take with
MySQL if we connected through MyODBC?
Thanks again,
Brad
-Original Message-
From: walt [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 11:47 AM
To: Brad Teale
Cc: '[EMAIL PROTECTED]'
Subject: Re: Real-time data warehousing
Brad,
We're
web servers on Linux,
but the big iron will always be Sun here (Company policy). There has been
talk of getting Oracle 9i? because Oracle has told us it is much faster, but
we are not holding our breath.
Thanks,
Brad Teale
-Original Message-
From: walt [mailto:[EMAIL PROTECTED]]
Sent
a good ingest machine. So I would
like to compile MySQL and MySQL++ with the Sun compilers to take full
advantage of everything the platform has to offer.
Any help would be great.
Thanks,
Brad Teale
Universal Weather and Aviation, Inc.
mailto:[EMAIL PROTECTED
-calc_hashnr)(key,length);
191: }
To fix the problem I poked around, and ended up commenting out lines
183-185. After this it compiles fine. Will this lead to any problems?
Computer Config:
SunOS 5.8 sun4u sparc SUNW, Ultra-80
Sun Workshop 6 update 2 5.3 2001/05/15
Thanks,
Brad Teale
Universal
columns reuse the deleted numbers?
2) I was wondering if the AUTO_INCREMENT columns wrapped back to 0 once they
run out of numbers on the top end?
3) If neither of these cases are true, is there a way to simulate number 2?
Thanks,
Brad Teale
Universal Weather and Aviation, Inc.
mailto:[EMAIL
14 matches
Mail list logo