We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

INFORMIX Database and VB5 Question

bmaranan
bmaranan asked
on
Medium Priority
281 Views
Last Modified: 2012-05-05
Hi everyone!

I wish i can seek some help from you guys. I have a project which I developed in VB5 with INFORMIX as a backend Database, I just want to know whats the reason why it execute a query "VERY SLOW".  
  I am using INFORMIX Data Director for VB5 to connect to INFORMIX database.  
  I run the same program using a MS Access Database and it run FAST as I expected.

WHAT can I do to resolve this query problem, I need your help guys this project is very URGENT.

thanks in advance!


Comment
Watch Question

Commented:
Hello,

Please try to execute your query passthrough and please verify your informix database indexes.

You can post the query and your table or tables and the indexes in use and i will try to help you

regards,

Author

Commented:
hi csalves,

how can i execute a passtrhrough query?


Commented:
Dim rs as recordset
dim sSQL as String

sSQL = "SELECT [Fields] FROM [table] ";

set rs = YourDB.OpenRecordset(sSQl,DbopenDynaset,dbsqlpassthrough)

The data contained in a passthrough query is read-only. after
you have to make dml operations with another instruction.

regards,
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.