Member Avatar for sandi009

Hello Everyone

I am using 2 different database servers to retrieve my data.

Some of my query retrieve data from one database server and some from other database server.

I had made connection successfully, But there is one problem.

The problem is that when I am retrieving data it is very slow.(It takes too time to execute my query).

Is there any way or solution to retrieve data fast.

  • 5 Contributors
  • 6 Replies
  • 162 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by masterjiraya
Member Avatar for asprin

Slow retreival of data can be attributed to many reasons. Some of them are:

  1. Not using optimized query
  2. Data set that is returned is very large
  3. Slow connection

It's difficult to pinpoint the problem without having a look at your code.

Member Avatar for diafol

Is your query using a JOIN on two servers?

Member Avatar for sandi009

Is your query using a JOIN on two servers?
No

Member Avatar for AminM

Try using singleton design pattert to only have 2 connections and not connecting each time you want to run a query.

Also, you can using profiling to spot slow functions or piece of code. Lookup xdebug extention.

Edited by AminM
Member Avatar for diafol

Show your code and queries.

Member Avatar for masterjiraya

yeah a bunch of us can help you alot. Do some normalization stuff

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.