Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Excessive memory increase problem in FbDataAdapter method even using dispose ( ) . [DNET673] #627

Closed
firebird-automations opened this issue Mar 18, 2016 · 6 comments

Comments

@firebird-automations
Copy link

Submitted by: Workdev Tecnologia da Informação LTDA (workdev)

The execution of the command every 1 minute considerably increases memory not reducing after dispose .

Note : When returning to version 4.7.0.0 is perceived that there was no problem .

@firebird-automations
Copy link
Author

Modified by: Workdev Tecnologia da Informação LTDA (workdev)

description: The execution of the command every 1 minute considerably increases memory not reducing after dispose . => The execution of the command every 1 minute considerably increases memory not reducing after dispose .

Note : When returning to version 4.7.0.0 is perceived that there was no problem .

@firebird-automations
Copy link
Author

Commented by: @cincuranet

Provide a test case.

@firebird-automations
Copy link
Author

Commented by: Workdev Tecnologia da Informação LTDA (workdev)

            dtConsulta\.Clear\(\);
            using \(FirebirdSql\.Data\.FirebirdClient\.FbDataAdapter
                daConsulta = new FirebirdSql\.Data\.FirebirdClient\.FbDataAdapter\("SELECT  "
                                                                        \+ "      CP\.documento, "
                                                                        \+ "      CP\.tp, "
                                                                        \+ "      CP\.modelo, "
                                                                        \+ "      CP\.operacao, "
                                                                        \+ "      CP\.local, "
                                                                        \+ "      CP\.operador, "
                                                                        \+ "      CP\.vlr\_total, "
                                                                        \+ "      CP\.vlr\_ad, "
                                                                        \+ "      CP\.vlr\_liquido, "
                                                                        \+ "      CP\.valor\_troco, "
                                                                        \+ "      CP\.valor\_troco\_contra\_vale, "
                                                                        \+ "      CP\.hora, "
                                                                        \+ "      EM\.im\_regime AS em\_regime "
                                                                        \+ "FROM SM\_MV\_PDV\_CB\_CUP CP "
                                                                        \+ "JOIN ST\_CD\_EMPRESAS EM ON CP\.empresa = EM\.codigo "
                                                                        \+ Condicao, clBancoDados\.StringConexao\)\)
            \{
                daConsulta\.Fill\(dtConsulta\);
            \}

Note : using the normal way to dispose and the using still remains the problem .

@firebird-automations
Copy link
Author

Commented by: @cincuranet

I need a runnable test case. This one I can't execute.

@firebird-automations
Copy link
Author

Commented by: Workdev Tecnologia da Informação LTDA (workdev)

Unfortunately I'm too little time to do this but I know the problem I tried to contribute . I will use version 4.7 .

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Closed [ 6 ]

resolution: Cannot Reproduce [ 5 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants