Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
can some one help me in informix database
Old 03-15-2010, 12:19 PM can some one help me in informix database
Experienced Talker

Posts: 37
Name: ahmad
Trades: 0
need to improve the performance of open connection of the informix DataBase
because it very turtle(slow),please.
EngAhmad is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 03-15-2010, 01:10 PM Re: can some one help me in informix database
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Optimise your queries??
Reduce the number of queries required/used?
Improve the data indexing?
Use faster hardware?

And probably several other guesses could be made. Some could be spot on, most will be useless.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 03-15-2010, 01:59 PM Re: can some one help me in informix database
Experienced Talker

Posts: 37
Name: ahmad
Trades: 0
the queries is improved but when i start debuger of .net and try to follow step by step
in F11 key, i see compiler take long time to open connection ..see line code below:
conn.open();//this line take long time to execute by compiler
EngAhmad is offline
Reply With Quote
View Public Profile
 
Old 03-15-2010, 02:54 PM Re: can some one help me in informix database
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
And "a long time" would be?

Local or Remote server?
Connection string?
ADODB?
DAO?
ODBC?

etc etc.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 03-15-2010, 04:05 PM Re: can some one help me in informix database
Experienced Talker

Posts: 37
Name: ahmad
Trades: 0
i find JCC rather than JDBC ,,,if there is some like this in .net ..plz help me.
EngAhmad is offline
Reply With Quote
View Public Profile
 
Old 03-15-2010, 04:18 PM Re: can some one help me in informix database
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
JCC?

Jewish Community Centre
Johannesburg Cricket Club.
John Cooper Clarke.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 03-15-2010, 04:25 PM Re: can some one help me in informix database
Experienced Talker

Posts: 37
Name: ahmad
Trades: 0

JCC refers to (Java Common Connectivity).
EngAhmad is offline
Reply With Quote
View Public Profile
 
Old 03-15-2010, 04:42 PM Re: can some one help me in informix database
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Did you not say you are working in .net??
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 03-15-2010, 05:36 PM Re: can some one help me in informix database
Experienced Talker

Posts: 37
Name: ahmad
Trades: 0
Thanks for Your Solution for my problem ,,,and thnx for your efforts
byeeeeee
???????!!!!!!!!
EngAhmad is offline
Reply With Quote
View Public Profile
 
Old 03-15-2010, 06:30 PM Re: can some one help me in informix database
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Nice to hear it's solved.

Amazing how we managed that with so little information!
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 03-16-2010, 01:00 PM Re: can some one help me in informix database
Experienced Talker

Posts: 37
Name: ahmad
Trades: 0
No Amazing in this world man,,every thing is Possible ,like my problem,,never solved,,,i wish some one can help me in my problem
EngAhmad is offline
Reply With Quote
View Public Profile
 
Old 03-16-2010, 02:38 PM Re: can some one help me in informix database
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
How about

If YOU give us more information about YOUR problem
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 03-17-2010, 05:34 AM Re: can some one help me in informix database
Experienced Talker

Posts: 37
Name: ahmad
Trades: 0
you tell me improve this

Local or Remote server?
Connection string?//how i can improve my connection string
ADODB?
DAO?
ODBC?
EngAhmad is offline
Reply With Quote
View Public Profile
 
Old 03-17-2010, 05:37 AM Re: can some one help me in informix database
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Until we KNOW WHAT YOU ARE USING WE CANNOT HELP!!!!!!!!!
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 03-17-2010, 06:47 AM Re: can some one help me in informix database
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
Quote:
Until we KNOW WHAT YOU ARE USING WE CANNOT HELP!!!!!!!!!
:-D

Keep calm Chris.
You'll only got an ulcer.

Laugh a bit with me instead.
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Old 03-17-2010, 06:56 AM Re: can some one help me in informix database
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0


Maybe it should have been the yellow pill after all
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 03-17-2010, 04:34 PM Re: can some one help me in informix database
Experienced Talker

Posts: 37
Name: ahmad
Trades: 0
Provider=;Data Source=;User ID=;Password=;
EngAhmad is offline
Reply With Quote
View Public Profile
 
Old 03-17-2010, 05:43 PM Re: can some one help me in informix database
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
Oh, me me me!
Let me try too!

Erm...
Let's see...
Egg, wall, pastry, plane, tambourine.

So, what do I win ?
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Old 03-18-2010, 02:39 AM Re: can some one help me in informix database
Experienced Talker

Posts: 37
Name: ahmad
Trades: 0
i see my thread is converted to breakfast...hahahahah,,,,
EngAhmad is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to can some one help me in informix database
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.51635 seconds with 12 queries