Massive MySQL database
I'm making a website which requires an absolutely massive mysql database, with potentially millions or even billions of rows in a single table.

The table structure is two "text" fields.

How can this be optimized for querying? I want to be able to fetch a single row at a time only, but as quickly as possible.

One field might have slightly longer text chunks, but the other one will have a relatively short one at all times, and any row selection will be done based on the other one.

Alternatively, is there a better way to store this many values?

Thank you for your help!
Massive MySQL database
===

I'm making a website which requires an absolutely massive mysql database, with potentially millions or even billions of rows in a single table.

The table structure is two "text" fields.

How can this be optimized for querying? I want to be able to fetch a single row at a time only, but as quickly as possible.

One field might have slightly longer text chunks, but the other one will have a relatively short one at all times, and any row selection will be done based on the other one.

Alternatively, is there a better way to store this many values?

Thank you for your help!