Best way to query a enormous database table

P

Patrick May

Lonifasiko said:
I'm working with MySQL as back-end and I must perform a heavy select
against a 250 columns table that could store near 1 million records
aproximately.

What's the best way to do this?
Click to expand...

Infrequently. ;-)

Regards,

Patrick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best way to do this? 13
What's the best way to extract 2 values from a CSV file from each row systematically? 6
Defining a data structure - is there a standard/best practice way? 1
Writting to file from Database 1
best way to display resultset? 3
Good or best way to allocate a large array 44
Script to interact with a database 9
Two of three SQL stmts execute: third results in table does not exist exception 2

Members online

No members online now.
Total: 28 (members: 1, guests: 27)
Robots: 193

Forum statistics

Threads
473,763
Messages
2,569,562
Members
45,038
Latest member
OrderProperKetocapsules

Latest Threads

Top