Viewing 4 posts - 1 through 5 (of 5 total)
I don't know cold fusion, but have u tried to put the code that ur page is supposed to do in a stored procedure?
As for ur original question, I have...
Mohamad Ad-Deeb
Senior Software Developer, Microtech
3 Mossadak st. Dokki 12311
Giza, Egypt.
Tel. +20 2 336 9855 (Ext.112)
Fax +20 2 749 8784
http://www.microtech-eg.com
November 23, 2005 at 2:11 am
quote:
I also thought exactly same at first but I tested both the queries with 40000 records in table_A, I tried without index,...
Mohamad Ad-Deeb
Senior Software Developer, Microtech
3 Mossadak st. Dokki 12311
Giza, Egypt.
Tel. +20 2 336 9855 (Ext.112)
Fax +20 2 749 8784
http://www.microtech-eg.com
October 21, 2003 at 6:20 am
Well, I guess these queries were enough if you ONLY need to return the first record for each DISTINCT nameIf you are migrating data and want to remove...
Mohamad Ad-Deeb
Senior Software Developer, Microtech
3 Mossadak st. Dokki 12311
Giza, Egypt.
Tel. +20 2 336 9855 (Ext.112)
Fax +20 2 749 8784
http://www.microtech-eg.com
October 16, 2003 at 7:33 am
My system is 3-tier and want to minimize the interaction with the databaseI use a certain query to get a certain set of results through a complicated SQL full...
Mohamad Ad-Deeb
Senior Software Developer, Microtech
3 Mossadak st. Dokki 12311
Giza, Egypt.
Tel. +20 2 336 9855 (Ext.112)
Fax +20 2 749 8784
http://www.microtech-eg.com
April 8, 2003 at 12:39 pm
Viewing 4 posts - 1 through 5 (of 5 total)