It doesn't run over the network.
The reports are requested from a website , and a record is inserted into the
ReportQueue.
And then the reports are run local on the Production machine and then
emailed to the recipient.
At this time only 2 people order reports.
Mary Stickney
TAG-TMI
Data
thanks. we are doing the data load today and will upgrade the MYODBC to
3.51 before we do it. This will be a good test as the load takes 6 hours
on the current version.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message-
From
. And the server is a faster machine then mine.
They run in 8 minutes on my test server , about 4 minutes each. Printing to
a PDF driver.
On the Production Server they take HOURS to run and print.
Any ideas...
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED
no it is dedicated to the DataWarehouse Report Processor.
runs one report at a time from a ReportQueue.
both have a local host.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]]
Sent
one other thing , the girl that made them did it with an Access database
copy of the warehouse.
I changed the connection to the real Datawarehouse.
if that makes any difference
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message
the
queue
and runs the reports one at a time and emails them out.
Outlook Express is running in order to email the PDF files to the recipient.
I can understand it being SOME slower , but not hours slower.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED
oh and my test server is my PC , so I had all kinds o crap running
on it at the same time.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 1:57 PM
that would be because b.name is inside the ' ' and it is taken as a
constant.
-Original Message-
From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 11:10 AM
To: [EMAIL PROTECTED]
Subject: like problem
i need this consult
select a.name from table1 a,
ok try this
select a.name from table1 a, table2 b where a.name like
'%'+ b.name + '%';
-Original Message-
From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 11:48 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: RE: like problem
yes, but select a.name
Short answer YES you have to have them
why because 2002-08-29 = 1965
-Original Message-
From: Johnny Withers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 1:30 PM
To: [EMAIL PROTECTED]
Subject: DATES and WHERE
I'm a bit confused here.. dates are not my strong point..
I
you cant update from is NOT supported
-Original Message-
From: Jakub Mach [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:15 AM
To: Mysql
Subject: SQL - Update problem
Hi,
how can I do sql command like this:
update sekce set pocet = count(*) from odkaz where
the join syntax is what is differnt between Access and MYSQL.
in MS-SQL = indexs will be used on tables mentioned in the JOIN clause
and they will not in MYSQL
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:40 AM
To: [EMAIL
I reported him already... to [EMAIL PROTECTED]
[EMAIL PROTECTED]
and several others..
also wrote back and asked if he thought I was a complete idiot...
-Original Message-
From: John Wards [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:49 AM
To: [EMAIL PROTECTED]
writingagentslot (WritingAgentSlot)
);
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:11 AM
To: Mary Stickney
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: MS Access and mySQL
Mary Stickney wrote:
the join
HE ALREADY DID FROM PREVIOUS EMAILS TO MY ACCOUNT... I HAVE A WEB PAGE AND
THEY
ARE MINING EMAIL ADDRESSES.. DUH
SAME BACK AT YOU
-Original Message-
From: Kenneth Hylton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:29 AM
To: 'Mary Stickney'; John Wards; [EMAIL
select hostid,patch.patchnumber from host
left join patch on host.hostid = patch.hostid
where patchnumber isnull
-Original Message-
From: Ajay Patel - SunService [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 2:27 PM
To: [EMAIL PROTECTED]
Subject: help with a query
I am
)
Subject: RE: Query Question
I suppose I should have specified that I would not be able to filter by
Data1
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 11:52 AM
To: Luc Foisy
Subject: RE: Query Question
select * from xxx
where
It doesn't suport alot of differnt things
it dosent have store procedures , dosent have a complete SQL command set...
I am using it becasue I am being forced to...
-Original Message-
From: Elizabeth Bogner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 9:25 PM
To:
I have been doing speed tests the same query ran on MYSQL took 45
minutes
on MS-SQL it took 11 minutes..
yes you do get what you pay for
-Original Message-
From: Francisco [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 8:47 AM
To: Mary Stickney; Elizabeth Bogner
What exactly is Trolling
I find MYSQL to be slow , sorry if that doesn't met with your approval.
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:15 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed
, August 16, 2002 9:21 AM
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Hi Mary,
I am not specially against or pro MySQL, Microsoft SQL
Server, Oracle or any other database. Teams make their
choices based on the project needs such as budget (is
your
]]
Sent: Friday, August 16, 2002 9:25 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Not to open a can of worms here, Mary, but I'd love to know exactly how you
got those results, since they basically contradict every known benchmark I
I did crash the MYSQL server the other day...
I am currently looping thru and getting the sales agent by agent.
I tried to do the query for all 804 agents at one time and after an hour and
a 1/2 and still not being done
decided against doing it that way.
next I decided I should have a table
),
KEY LobIdIndex (LOBID)
);
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:15 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Mary Stickney wrote:
I have been doing speed tests the same query ran
I did send in my query the day I joined this list and the table
structures.
I just did again...
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:47 AM
To: Mary Stickney
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed
query was it may I ask ?
Tom
- Original Message -
From: Mary Stickney [EMAIL PROTECTED]
To: Francisco [EMAIL PROTECTED]; Elizabeth Bogner
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 11:52 PM
Subject: RE: MySQL vs. Oracle (not speed)
I have been doing speed tests
speed is of the utmost importance ,
I can't have a client run a report and wait 2 days for it to finish.
-Original Message-
From: Aron Pilhofer [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:46 AM
To: Mary Stickney; [EMAIL PROTECTED]; Francisco; Elizabeth Bogner;
[EMAIL
;ProductIdIndex;15;AdminCoverage.ProductId;1
1;
;tempsap;ALL;10019;
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:21 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed
yes I do
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:37 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Do you have an index on AdminProducer.taxid
Stickney; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Could you please send also tempsap ?
Thanks and regards,
Jocelyn
- Original Message -
From: Mary Stickney [EMAIL PROTECTED]
To: Mark Matthews [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 16
problems with MySQL there
is an entire list of people who are willing to offer support for free. Post
your query and some table information and let's see if we can clear up your
performance issues.
John Griffin
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Friday
be
plaiged with performance problems. Insulting someone will not help convert
them to MySQL it will drive people away.
Anyway enough of my rant...
Serge.
On Fri, 16 Aug 2002 09:46:44 -0500
Mark Matthews [EMAIL PROTECTED] wrote:
Mary Stickney wrote:
What exactly is Trolling
I find
incidentaly... Primary keys cant not be made on most of these tables due to
the fact that
the farther back in time you got the more screwed up the data is...
Fields have been added and they did not have the info to fill in the
blanks...
-Original Message-
From: Mary Stickney [mailto
looks to me like I can only make indexes on fields that are not null...
this one is not , not null
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:34 AM
To: Mary Stickney; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQL vs
no I am using myisam it was just a limitation of DBTOOLS
I am getting it done using alter table
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Van
Sent: Friday, August 16, 2002 1:06 PM
To: Mary Stickney
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL
it was a limitation of the DBTOOLS table manager... I am indexing right now
using alter table...
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:08 PM
To: Mary Stickney
Cc: Jocelyn Fournier; Mark Matthews; [EMAIL PROTECTED]
Subject: Re
.
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:48 PM
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Hi Mary,
My opinion:
MySQL forums are open to every one to said about him MySQL
problems
for reports only
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 2:14 PM
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
...in this case...is very sad.
You use this query to generate
ok fixed thoes every little bit helps... I hope.
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:00 PM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
I also noticed the field where you make
ok , but I have now just programmed around the error
to meet my deadline...
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Re: RE: null
Mary,
Wednesday, August 14, 2002, 7:23:47 PM,
,RegionCode,FirstYearSales,SecondYearSales,ThirdyearSales,Perc
entOfCases,producerid,distributioncode,PremiumsInForce) VALUES
(080323288,'PIC' , '2000','2001', '2002',
'3/30/2002','0B917','N0305',1,'7B',0,0,18.59,50,'0B917','D4073',18.59)
yet it brings back NULL in a select statment
Mary Stickney
:11 AM
To: Mary Stickney
Cc: [EMAIL PROTECTED]
Subject: Re: null
That is really odd, because I don't see a select statement anywhere.
Mary Stickney wrote:
SQL QUERY SQL QUERY
I inserted a row , and set the sales to 0 for the years that there is none
,
and set the sales to the sales amount for th
, _
AdminCoverage.CoverageIdSbc,AdminHierarchy.ProducerID
Call SendToDwDb(sSql, rs3)
Mary Stickney
TAG-TMI
Data Warehouse / Imaging
402-474-7612 x 3099
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
select * from forms_data_recs
where fdr_form_id='37' and ( fdr_ff_id ='190' and ( fdr_value like
'%keith%' ))
OR ( fdr_ff_id = '192' and (fdr_value like '%public%' ))
order by fdr_date,fdr_id
-Original Message-
From: Keith Clay [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002
44 matches
Mail list logo