Board index » delphi » DBexpress D7 and Mysql with 20 000 records (300 MO) pb

DBexpress D7 and Mysql with 20 000 records (300 MO) pb

hello
i ve a database with 4 field ,one is a blob with jpg image 13ko
I use SQLtable > datasetprovider >clientdataset and datasource

and when i open the datasource and start to browse the used memory of the pc
is growing an growing
(i made a small viewer for the jpg)
what is  the solution

DAVID

 

Re:DBexpress D7 and Mysql with 20 000 records (300 MO) pb


Don't load the jpg in the primary query and just load the image on-request using
a secondary query.

Quote
Cei wrote:
> hello
> i ve a database with 4 field ,one is a blob with jpg image 13ko
> I use SQLtable > datasetprovider >clientdataset and datasource

> and when i open the datasource and start to browse the used memory of the pc
> is growing an growing
> (i made a small viewer for the jpg)
> what is  the solution

> DAVID

--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
Guiller...@GrupoMillennium.com
http://www.GrupoMillennium.com

Other Threads