• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

The best way to store a really big table

We need to save thousands of PDF files into a MySQL table, then Which is the faster way to do it  (Engine, Index, etc...) The table will have about 50GB

(We tried MyISAM and partition method with poor results)

Regards
0
lnrivera
Asked:
lnrivera
1 Solution
 
K VDatabase ConsultantCommented:
store pdfs on drive and path in database.
0
 
lnriveraAuthor Commented:
But, then How can I retrieve from  remote client, the only connection that the remote client has is the MySQL connection using 3306 port
0
 
mayank_joshiCommented:
you should use both indexing and partitioning in table.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now