SqlDbx Forum

SqlDbx

You are not logged in.

#1 2010-01-14 06:36:17

devilyeye
Member

select issue

I just use select * from a table had 0.5 millon records. But it shows query complete with error after about 30 seconds, and only about 300  thousand result. Is it a bug?

Offline

#2 2010-01-14 07:49:16

sqldbxhelp
Administrator

Re: select issue

What error you get?
In general the number of results SqlDbx able to retrieve
depends on amount of memory you have installed and
how many other results windows you have open.

Offline

#3 2010-01-14 21:50:48

devilyeye
Member

Re: select issue

Thanks for reply.
You mean the physical memory installed?  It has 2 GB, and more then 1 GB free memory when I excuted this query.
The message window shows query completed with errors, and no other result window opened.

Offline

#4 2010-01-14 21:56:20

devilyeye
Member

Re: select issue

I tried the same query on another computer with 4 GB memory and the number of result was correct and no error appeared in the message window.

Offline

Board footer

Powered by FluxBB