Solved

The best way to store a really big table

Posted on 2011-02-28
3
269 Views
Last Modified: 2012-05-11
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
Comment
Question by:lnrivera
3 Comments
 
LVL 21

Accepted Solution

by:
theGhost_k8 earned 500 total points
ID: 34995286
store pdfs on drive and path in database.
0
 

Author Comment

by:lnrivera
ID: 34995689
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
 
LVL 9

Expert Comment

by:mayank_joshi
ID: 34996129
you should use both indexing and partitioning in table.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question