Member Avatar for apanimesh061

I have a database of 1000K values.
How can I use PHP to parse that database in less time ?
I am using a foreach loop fr comparison but it takes 15 minutes to parse all data!

Should change be done in PHP or SQL ?

Please help !

  • 2 Contributors
  • 1 Reply
  • 61 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by |-|x
Member Avatar for |-|x

What exactly do you mean by parse? Are you searching for specific values in the data?

I would almost guarantee that doing these operations in an SQL script will be faster than processing manually in any programming language.

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.