Search the web
Sign In
New User? Sign Up
firebird-support · Support for Users of Firebird Releases
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.

Messages

  Messages Help
Advanced
Messages 97519 - 97548 of 97548   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
97519
I expect the answer to be NO, but I want to try anyway (Firebird has its surprises from time to time): Is there a way to insert Blob data via a script command....
Stefan Heymann
stefanheymann
Offline Send Email
Oct 10, 2008
12:49 pm
97520
... The FSQL[0] script utility can load data into a blob from external files. Something like (IIRC): INSERT INTO MYTABLE (ID, BLOBFIELD) VALUES (1,...
Scott Morgan
temp1066
Offline Send Email
Oct 10, 2008
1:08 pm
97521
Thanks Helen, I'll try all of your suggestions and try to adjust things to run sweetly. ... Yup....
mlq97
Offline Send Email
Oct 10, 2008
1:12 pm
97522
... No - Firebird supports only b*tree indexes. For more information try here: http://www.ibphoenix.com/main.nfs?page=ibp_expert1 ... I'm not quite sure what...
Ann W. Harrison
annwharrison
Offline Send Email
Oct 10, 2008
3:41 pm
97523
... It is only 32,000. Ivan...
Ivan Prenosil
iprenosil
Offline Send Email
Oct 10, 2008
3:58 pm
97524
... From: Adriano dos Santos Fernandes <adrianosf@...> Subject: Re: [firebird-support] Re: unable to allocate memory exception ... Adriano, any...
unordained
tigereye_philip
Offline Send Email
Oct 10, 2008
6:24 pm
97525
Some of the columns in one of my tables contain mainly nulls, others contain very few. I am trying to improve performance of a procedure which updates many ...
mlq97
Offline Send Email
Oct 10, 2008
6:32 pm
97526
... From: "unordained" <unordained_00@...> To: firebird-support@yahoogroups.com Sent: Fri, 10 Oct 2008 13:24:49 -0500 Subject: Re: [firebird-support]...
unordained
tigereye_philip
Offline Send Email
Oct 10, 2008
6:42 pm
97527
Hi Sergio, sorry for answering late, but I didn't have any time to try out my idea before now... Since I'm normally using Firebird 1.5, I've no experience in...
Svein Erling Tysvaer
svein_erling
Offline Send Email
Oct 10, 2008
8:49 pm
97528
... What does the test look like (actual code)? ./heLen...
Helen Borrie
helebor
Offline Send Email
Oct 10, 2008
9:52 pm
97529
... Actually yes. Firebird will automatically cast a varchar to a blob, so just write your insert statement as if it were a varchar field. However there are...
Adam
s3057043
Offline Send Email
Oct 10, 2008
10:24 pm
97530
... OK, then this FAQ is incorrect: http://www.firebirdfaq.org/faq61/ Adam...
Adam
s3057043
Offline Send Email
Oct 10, 2008
10:27 pm
97531
... I built a new trigger for testing and now performance is fast on each of the columns. I'm not sure what the problem was, but it seems OK now. M....
mlq97
Offline Send Email
Oct 11, 2008
3:25 pm
97532
Greets: I'm on Ubuntu using 2.1-super (Marius install). I know I'm missing something very mundane, but I've been at this for a couple days, and I can't seem to...
Kurt Federspiel
federonline
Offline Send Email
Oct 11, 2008
10:05 pm
97533
Hi I am trying to optimize the following count query by changing it to an exists query. I have tried various exists statements but I cannot seem to get it...
dinol.softedge
Offline Send Email
8:03 am
97534
As far as I can see, you're trying to actually select an employee count by using a join with a 1-M realtionship. How could that be returned with an exists...
Kjell Rilbe
krilbe
Offline Send Email
8:13 am
97535
Hi Sorry for not being clearer. I don't need to count the employees, just find out if there is at least one per record in the tbl_job_card table ... with...
dinol.softedge
Offline Send Email
8:18 am
97536
In general I've found joins to be faster than subqueries with count or exists. I guess joins are easier to optimize than the other kinds. (?) In theory, an...
Kjell Rilbe
krilbe
Offline Send Email
8:30 am
97537
Hi Kjell Yes that is twice as fast. It still takes 3 seconds to execute though for only 2500 records. It has 3.8 million non-indexed reads to the ...
dinol.softedge
Offline Send Email
9:04 am
97538
I'm sure others will come up with good indexing suggestions. I don't have time to dive into that right now. Sorry. But what I usually do is to create multiple...
Kjell Rilbe
krilbe
Offline Send Email
9:09 am
97539
Also, keep an eye on index selectivity. Maybe start with updating index statistics for the indexes you already have? Kjell ... -- ... Kjell Rilbe DataDIA AB ...
Kjell Rilbe
krilbe
Offline Send Email
9:10 am
97540
... You only need an inner join to make this happen: SELECT tjc.EXCESS_PAID, tjc.JOB_CARD_ID, tjc.TIME_START, tjc.TIME_FINISH, tjc....l tjc.TIME_TAKEN, ...
Helen Borrie
helebor
Offline Send Email
9:36 am
97541
Thanks Helen and Kjell Helen won't that create multiple rows if there is more than one employee? I need only one row per job card and all I'm really trying to...
dinol.softedge
Offline Send Email
9:48 am
97542
With an inner join you will get one master row for each detail row, yes. I thought you wanted one row per master record, no matter what, and in one result set...
Kjell Rilbe
krilbe
Offline Send Email
9:53 am
97543
Here is a performance summary of the query Query Time ... Prepare : 16 Execute : 3 978 Avg fetch time: 1.48 ms Memory ... Current: 1 325 744 Max...
dinol.softedge
Offline Send Email
9:54 am
97544
... Yes, it will, if you have multiple employees on that job card. You said "I don't need to count the employees, just find out if there is at least one per...
Helen Borrie
helebor
Offline Send Email
10:13 am
97545
What I really want is this. The query must always show 1 master record irrespective of the number of detail records but there must also be a row that shows...
dinol.softedge
Offline Send Email
10:19 am
97546
... This is what I've been trying to answer. But you made a typo. You meant "there must also be a *column* that shows...". Right? Kjell -- ... Kjell Rilbe ...
Kjell Rilbe
krilbe
Offline Send Email
10:25 am
97547
... Don't you mean "an output field"? I hope so. SELECT tjc.EXCESS_PAID, tjc.JOB_CARD_ID, tjc.TIME_START, tjc.TIME_FINISH, tjc....l tjc.TIME_TAKEN, tc.ADDRESS...
Helen Borrie
helebor
Offline Send Email
12:07 pm
97548
At 23:07 12/10/2008, Helen Borrie wrote: .... select case when (exists (select 1 from TBL_JOB_CARD_EMPLOYEE tjce where tjce.JOB_CARD_ID = tjc.JOB_CARD_ID))...
Helen Borrie
helebor
Offline Send Email
12:33 pm
Messages 97519 - 97548 of 97548   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2007 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help